From a 500-row sample across 10 columns.
| caseid | student_s_community_school | student_s_representative | date_on_which_doe_received | date_on_which_doe_referred | date_on_which_the_parent | date_on_which_doe_received_1 | date_doe_received_signed | date_doe_approved_written | date_doe_issued_first_payment |
|---|---|---|---|---|---|---|---|---|---|
| 20210001 | District 03 | Attorney | 2020-06-15T00:00:00.000 | 2020-07-02T00:00:00.000 | 2021-02-04T00:00:00.000 | 2021-02-02T00:00:00.000 | 2021-03-17T00:00:00.000 | 2021-03-24T00:00:00.000 | 2021-04-22T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
caseid | text | — | 0% | 202108632021066720211395 |
student_s_community_school | text | — | 0% | District 02District 03District 15 |
student_s_representative | categorical | — | 0% | AttorneyNon-attorney AdvocateNon-Attorney Advocateof 4 |
date_on_which_doe_received | datetime | — | 0% | 2020-08-25T00:00:00.0002020-08-24T00:00:00.000 |
GET /api/datasets/ekck-c5sb GET /api/datasets/ekck-c5sb/quality GET /api/datasets/ekck-c5sb/related GET /api/columns?dataset=ekck-c5sb
| 20210002 |
| District 03 |
| Attorney |
| 2020-06-15T00:00:00.000 |
| 2020-06-30T00:00:00.000 |
| 2021-02-16T00:00:00.000 |
| 2021-02-12T00:00:00.000 |
| 2021-02-22T00:00:00.000 |
| 2021-02-24T00:00:00.000 |
| 2021-04-28T00:00:00.000 |
| 20210003 | District 03 | Attorney | 2020-06-15T00:00:00.000 | 2020-06-30T00:00:00.000 | 2021-05-21T00:00:00.000 | 2021-05-06T00:00:00.000 | 2021-06-09T00:00:00.000 | 2021-08-23T00:00:00.000 | 2021-09-01T00:00:00.000 |
| 20210004 | District 09 | Attorney | 2020-06-15T00:00:00.000 | 2020-06-30T00:00:00.000 | 2021-02-03T00:00:00.000 | 2021-01-26T00:00:00.000 | 2021-03-01T00:00:00.000 | 2021-03-15T00:00:00.000 | 2021-03-24T00:00:00.000 |
| 20210005 | District 14 | Attorney | 2020-06-13T00:00:00.000 | 2020-06-29T00:00:00.000 | 2021-02-18T00:00:00.000 | 2021-02-18T00:00:00.000 | 2021-02-23T00:00:00.000 | 2021-02-25T00:00:00.000 | 2021-03-26T00:00:00.000 |
| 20210006 | District 03 | Attorney | 2020-06-15T00:00:00.000 | 2020-07-06T00:00:00.000 | 2021-05-21T00:00:00.000 | 2021-05-14T00:00:00.000 | 2021-07-02T00:00:00.000 | 2021-07-28T00:00:00.000 | 2021-09-02T00:00:00.000 |
| 20210007 | District 02 | Attorney | 2020-06-15T00:00:00.000 | 2020-06-30T00:00:00.000 | 2021-04-05T00:00:00.000 | 2021-03-31T00:00:00.000 | 2021-06-04T00:00:00.000 | 2021-10-06T00:00:00.000 | 2021-10-19T00:00:00.000 |
| 20210008 | District 06 | Attorney | 2020-06-15T00:00:00.000 | 2020-06-30T00:00:00.000 | 2021-10-13T00:00:00.000 | 2021-09-17T00:00:00.000 | 2021-10-19T00:00:00.000 | 2021-10-20T00:00:00.000 | N/A |
| 20210009 | District 02 | Attorney | 2020-06-15T00:00:00.000 | 2020-06-30T00:00:00.000 | 2021-07-20T00:00:00.000 | 2021-06-25T00:00:00.000 | 2021-07-27T00:00:00.000 | 2021-08-06T00:00:00.000 | N/A |
| 20210010 | District 22 | Attorney | 2020-06-15T00:00:00.000 | 2020-06-29T00:00:00.000 | 2021-01-06T00:00:00.000 | 2020-12-29T00:00:00.000 | 2021-03-09T00:00:00.000 | 2021-05-17T00:00:00.000 | N/A |
2020-06-17T00:00:00.000date_on_which_doe_referred | datetime | — | 0% | 2020-09-16T00:00:00.0002020-09-10T00:00:00.0002020-09-15T00:00:00.000 |
date_on_which_the_parent | datetime | — | 0% | 2021-02-25T00:00:00.0002021-04-15T00:00:00.0002021-05-04T00:00:00.000 |
date_on_which_doe_received_1 | datetime | — | 0% | 2021-06-04T00:00:00.0002021-07-16T00:00:00.0002021-03-02T00:00:00.000 |
date_doe_received_signed | datetime | — | 0% | 2021-04-19T00:00:00.0002021-05-14T00:00:00.0002021-05-04T00:00:00.000 |
date_doe_approved_written | datetime | — | 0% | 2021-07-02T00:00:00.0002021-07-29T00:00:00.0002021-09-20T00:00:00.000 |
date_doe_issued_first_payment | datetime | — | 0% | N/A2021-07-14T00:00:00.0002021-08-19T00:00:00.000 |