ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where deaths = 10 and fips = 51036 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 |
---|---|---|---|---|---|---|---|
1062942 | 1062942 | 2021-02-24 | Charles City | Virginia | 51036 | 393 | 10 |
1059697 | 1059697 | 2021-02-23 | Charles City | Virginia | 51036 | 392 | 10 |
1056451 | 1056451 | 2021-02-22 | Charles City | Virginia | 51036 | 392 | 10 |
1053205 | 1053205 | 2021-02-21 | Charles City | Virginia | 51036 | 391 | 10 |
1049958 | 1049958 | 2021-02-20 | Charles City | Virginia | 51036 | 389 | 10 |
1046711 | 1046711 | 2021-02-19 | Charles City | Virginia | 51036 | 388 | 10 |
1043466 | 1043466 | 2021-02-18 | Charles City | Virginia | 51036 | 387 | 10 |
1040221 | 1040221 | 2021-02-17 | Charles City | Virginia | 51036 | 385 | 10 |
1036976 | 1036976 | 2021-02-16 | Charles City | Virginia | 51036 | 382 | 10 |
1033731 | 1033731 | 2021-02-15 | Charles City | Virginia | 51036 | 378 | 10 |
1030485 | 1030485 | 2021-02-14 | Charles City | Virginia | 51036 | 377 | 10 |
1027238 | 1027238 | 2021-02-13 | Charles City | Virginia | 51036 | 376 | 10 |
1023993 | 1023993 | 2021-02-12 | Charles City | Virginia | 51036 | 373 | 10 |
1020748 | 1020748 | 2021-02-11 | Charles City | Virginia | 51036 | 371 | 10 |
1017503 | 1017503 | 2021-02-10 | Charles City | Virginia | 51036 | 369 | 10 |
1014258 | 1014258 | 2021-02-09 | Charles City | Virginia | 51036 | 365 | 10 |
1011013 | 1011013 | 2021-02-08 | Charles City | Virginia | 51036 | 366 | 10 |
1007767 | 1007767 | 2021-02-07 | Charles City | Virginia | 51036 | 362 | 10 |
1004521 | 1004521 | 2021-02-06 | Charles City | Virginia | 51036 | 359 | 10 |
1001275 | 1001275 | 2021-02-05 | Charles City | Virginia | 51036 | 357 | 10 |
998029 | 998029 | 2021-02-04 | Charles City | Virginia | 51036 | 351 | 10 |
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);