ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where county = "Unknown", deaths = 2 and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501371 | 2501371 | 2022-05-13 | Unknown | New Hampshire | 4382 | 2 | |
2498113 | 2498113 | 2022-05-12 | Unknown | New Hampshire | 4416 | 2 | |
2494855 | 2494855 | 2022-05-11 | Unknown | New Hampshire | 4387 | 2 | |
2491597 | 2491597 | 2022-05-10 | Unknown | New Hampshire | 4428 | 2 | |
2488339 | 2488339 | 2022-05-09 | Unknown | New Hampshire | 4471 | 2 | |
2485082 | 2485082 | 2022-05-08 | Unknown | New Hampshire | 5016 | 2 | |
2481824 | 2481824 | 2022-05-07 | Unknown | New Hampshire | 5016 | 2 | |
2478566 | 2478566 | 2022-05-06 | Unknown | New Hampshire | 5016 | 2 | |
2475308 | 2475308 | 2022-05-05 | Unknown | New Hampshire | 5056 | 2 | |
2472051 | 2472051 | 2022-05-04 | Unknown | New Hampshire | 5109 | 2 | |
2468795 | 2468795 | 2022-05-03 | Unknown | New Hampshire | 5148 | 2 | |
2465539 | 2465539 | 2022-05-02 | Unknown | New Hampshire | 5165 | 2 | |
2462284 | 2462284 | 2022-05-01 | Unknown | New Hampshire | 5137 | 2 | |
2459028 | 2459028 | 2022-04-30 | Unknown | New Hampshire | 5137 | 2 | |
2455772 | 2455772 | 2022-04-29 | Unknown | New Hampshire | 5137 | 2 | |
2452516 | 2452516 | 2022-04-28 | Unknown | New Hampshire | 5154 | 2 | |
2449260 | 2449260 | 2022-04-27 | Unknown | New Hampshire | 5182 | 2 | |
2446003 | 2446003 | 2022-04-26 | Unknown | New Hampshire | 5160 | 2 | |
2442748 | 2442748 | 2022-04-25 | Unknown | New Hampshire | 5147 | 2 | |
2439492 | 2439492 | 2022-04-24 | Unknown | New Hampshire | 5893 | 2 | |
2436236 | 2436236 | 2022-04-23 | Unknown | New Hampshire | 5893 | 2 | |
2432980 | 2432980 | 2022-04-22 | Unknown | New Hampshire | 5893 | 2 | |
2429724 | 2429724 | 2022-04-21 | Unknown | New Hampshire | 5862 | 2 | |
2423212 | 2423212 | 2022-04-19 | Unknown | New Hampshire | 5867 | 2 | |
2419955 | 2419955 | 2022-04-18 | Unknown | New Hampshire | 5930 | 2 | |
2416700 | 2416700 | 2022-04-17 | Unknown | New Hampshire | 5910 | 2 | |
2413444 | 2413444 | 2022-04-16 | Unknown | New Hampshire | 5910 | 2 | |
2410188 | 2410188 | 2022-04-15 | Unknown | New Hampshire | 5910 | 2 | |
2406932 | 2406932 | 2022-04-14 | Unknown | New Hampshire | 5885 | 2 | |
2403676 | 2403676 | 2022-04-13 | Unknown | New Hampshire | 6075 | 2 | |
2400421 | 2400421 | 2022-04-12 | Unknown | New Hampshire | 6117 | 2 | |
2397166 | 2397166 | 2022-04-11 | Unknown | New Hampshire | 6548 | 2 | |
2393911 | 2393911 | 2022-04-10 | Unknown | New Hampshire | 6638 | 2 | |
2390655 | 2390655 | 2022-04-09 | Unknown | New Hampshire | 6638 | 2 | |
2387399 | 2387399 | 2022-04-08 | Unknown | New Hampshire | 6638 | 2 | |
1880140 | 1880140 | 2021-11-03 | Unknown | New Hampshire | 784 | 2 | |
1876891 | 1876891 | 2021-11-02 | Unknown | New Hampshire | 775 | 2 | |
1873642 | 1873642 | 2021-11-01 | Unknown | New Hampshire | 748 | 2 | |
980642 | 980642 | 2021-01-30 | Unknown | New Hampshire | 1042 | 2 |
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);