ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where county = "Surry", deaths = 140 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1149633 | 1149633 | 2021-03-23 | Surry | North Carolina | 37171 | 7570 | 140 |
1146386 | 1146386 | 2021-03-22 | Surry | North Carolina | 37171 | 7566 | 140 |
1143139 | 1143139 | 2021-03-21 | Surry | North Carolina | 37171 | 7556 | 140 |
1139892 | 1139892 | 2021-03-20 | Surry | North Carolina | 37171 | 7556 | 140 |
1136646 | 1136646 | 2021-03-19 | Surry | North Carolina | 37171 | 7542 | 140 |
1133400 | 1133400 | 2021-03-18 | Surry | North Carolina | 37171 | 7538 | 140 |
1130152 | 1130152 | 2021-03-17 | Surry | North Carolina | 37171 | 7527 | 140 |
1126905 | 1126905 | 2021-03-16 | Surry | North Carolina | 37171 | 7510 | 140 |
1123659 | 1123659 | 2021-03-15 | Surry | North Carolina | 37171 | 7501 | 140 |
1120413 | 1120413 | 2021-03-14 | Surry | North Carolina | 37171 | 7487 | 140 |
1117166 | 1117166 | 2021-03-13 | Surry | North Carolina | 37171 | 7487 | 140 |
1113919 | 1113919 | 2021-03-12 | Surry | North Carolina | 37171 | 7485 | 140 |
1110673 | 1110673 | 2021-03-11 | Surry | North Carolina | 37171 | 7477 | 140 |
1107427 | 1107427 | 2021-03-10 | Surry | North Carolina | 37171 | 7461 | 140 |
1104181 | 1104181 | 2021-03-09 | Surry | North Carolina | 37171 | 7457 | 140 |
1100935 | 1100935 | 2021-03-08 | Surry | North Carolina | 37171 | 7455 | 140 |
1097689 | 1097689 | 2021-03-07 | Surry | North Carolina | 37171 | 7443 | 140 |
1094441 | 1094441 | 2021-03-06 | Surry | North Carolina | 37171 | 7443 | 140 |
1091195 | 1091195 | 2021-03-05 | Surry | North Carolina | 37171 | 7426 | 140 |
1087950 | 1087950 | 2021-03-04 | Surry | North Carolina | 37171 | 7413 | 140 |
1084705 | 1084705 | 2021-03-03 | Surry | North Carolina | 37171 | 7401 | 140 |
1081459 | 1081459 | 2021-03-02 | Surry | North Carolina | 37171 | 7383 | 140 |
1078213 | 1078213 | 2021-03-01 | Surry | North Carolina | 37171 | 7379 | 140 |
1074968 | 1074968 | 2021-02-28 | Surry | North Carolina | 37171 | 7368 | 140 |
1071722 | 1071722 | 2021-02-27 | Surry | North Carolina | 37171 | 7368 | 140 |
1068476 | 1068476 | 2021-02-26 | Surry | North Carolina | 37171 | 7348 | 140 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);