From a 500-row sample across 9 columns.
numbermonthyear+5numbermonthyear+5countymonth| first_name | last_name | soundex | county | number | age | year | month | day |
|---|---|---|---|---|---|---|---|---|
| William | Phelan | P450 | manhattan | 4 | 1 m | 1867 | jan | 2 |
| Edward | Lynch | L520 | manhattan | 5 | 11 m | 1867 | jan | 1 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
first_name | text | First name and middle name/initial on the certificate | 4% | JohnMaryWilliam |
last_name | text | Last name on the birth certificate | 4% | SmithBrownJohnson |
soundex | text | A phonetic algorithm for indexing names by sound | 4% | S530M600B650 |
county | categorical | Borough in which the certificate was issued. | 0% | kingsmanhattanbronxof 5 |
GET /api/datasets/797j-9xvg GET /api/datasets/797j-9xvg/quality GET /api/datasets/797j-9xvg/related GET /api/columns?dataset=797j-9xvg
| Mary Elizabeth |
| Egan |
| E250 |
| manhattan |
| 8 |
| 4 y |
| 1867 |
| jan |
| 1 |
| James J | Hackett | H230 | manhattan | 9 | 21 y | 1867 | jan | 2 |
| Jeremiah | O'Kerley | O264 | manhattan | 10 | 2 m | 1867 | jan | 1 |
| Philip | Monahan | M550 | manhattan | 11 | 5 y | 1867 | jan | 4 |
| Felix | Smith | S530 | manhattan | 13 | 40 y | 1867 | jan | 1 |
| Herman | Lowenatein | L535 | manhattan | 16 | 3 m | 1867 | jan | 5 |
| Bridget | McDermott | M236 | manhattan | 17 | 70 y | 1867 | jan | 6 |
| Christopher | Doyle | D400 | manhattan | 18 | 23 y | 1867 | jan | 6 |
number| text |
| Certificate number on the document |
| 0% |
68111154 |
age | text | Length of time person has lived | 4% | 1 y60 y65 y |
year | integer | Year of Birth on the certificate | 0% | 194319481947 |
month | categorical | Month of Birth on the certificate | 4% | janmarfebof 19 |
day | text | Day of Birth on the certificate | 4% | 251 |