ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,565 rows where county = "Simpson" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500685 | 2500685 | 2022-05-13 | Simpson | Kentucky | 21213 | 5635 | 94 |
2501056 | 2501056 | 2022-05-13 | Simpson | Mississippi | 28127 | 7026 | 149 |
2497427 | 2497427 | 2022-05-12 | Simpson | Kentucky | 21213 | 5635 | 94 |
2497798 | 2497798 | 2022-05-12 | Simpson | Mississippi | 28127 | 7026 | 149 |
2494169 | 2494169 | 2022-05-11 | Simpson | Kentucky | 21213 | 5635 | 94 |
2494540 | 2494540 | 2022-05-11 | Simpson | Mississippi | 28127 | 7026 | 149 |
2490911 | 2490911 | 2022-05-10 | Simpson | Kentucky | 21213 | 5635 | 94 |
2491282 | 2491282 | 2022-05-10 | Simpson | Mississippi | 28127 | 7026 | 149 |
2487654 | 2487654 | 2022-05-09 | Simpson | Kentucky | 21213 | 5635 | 94 |
2488025 | 2488025 | 2022-05-09 | Simpson | Mississippi | 28127 | 7026 | 149 |
2484396 | 2484396 | 2022-05-08 | Simpson | Kentucky | 21213 | 5627 | 92 |
2484767 | 2484767 | 2022-05-08 | Simpson | Mississippi | 28127 | 7018 | 149 |
2481138 | 2481138 | 2022-05-07 | Simpson | Kentucky | 21213 | 5627 | 92 |
2481509 | 2481509 | 2022-05-07 | Simpson | Mississippi | 28127 | 7018 | 149 |
2477880 | 2477880 | 2022-05-06 | Simpson | Kentucky | 21213 | 5627 | 92 |
2478251 | 2478251 | 2022-05-06 | Simpson | Mississippi | 28127 | 7018 | 149 |
2474622 | 2474622 | 2022-05-05 | Simpson | Kentucky | 21213 | 5627 | 92 |
2474993 | 2474993 | 2022-05-05 | Simpson | Mississippi | 28127 | 7018 | 149 |
2471365 | 2471365 | 2022-05-04 | Simpson | Kentucky | 21213 | 5627 | 92 |
2471736 | 2471736 | 2022-05-04 | Simpson | Mississippi | 28127 | 7018 | 149 |
2468109 | 2468109 | 2022-05-03 | Simpson | Kentucky | 21213 | 5627 | 92 |
2468480 | 2468480 | 2022-05-03 | Simpson | Mississippi | 28127 | 7018 | 149 |
2464854 | 2464854 | 2022-05-02 | Simpson | Kentucky | 21213 | 5627 | 92 |
2465225 | 2465225 | 2022-05-02 | Simpson | Mississippi | 28127 | 7018 | 149 |
2461598 | 2461598 | 2022-05-01 | Simpson | Kentucky | 21213 | 5622 | 91 |
2461969 | 2461969 | 2022-05-01 | Simpson | Mississippi | 28127 | 7013 | 148 |
2458342 | 2458342 | 2022-04-30 | Simpson | Kentucky | 21213 | 5622 | 91 |
2458713 | 2458713 | 2022-04-30 | Simpson | Mississippi | 28127 | 7013 | 148 |
2455086 | 2455086 | 2022-04-29 | Simpson | Kentucky | 21213 | 5622 | 91 |
2455457 | 2455457 | 2022-04-29 | Simpson | Mississippi | 28127 | 7013 | 148 |
2451830 | 2451830 | 2022-04-28 | Simpson | Kentucky | 21213 | 5622 | 91 |
2452201 | 2452201 | 2022-04-28 | Simpson | Mississippi | 28127 | 7013 | 148 |
2448574 | 2448574 | 2022-04-27 | Simpson | Kentucky | 21213 | 5622 | 91 |
2448945 | 2448945 | 2022-04-27 | Simpson | Mississippi | 28127 | 7013 | 148 |
2445318 | 2445318 | 2022-04-26 | Simpson | Kentucky | 21213 | 5622 | 91 |
2445689 | 2445689 | 2022-04-26 | Simpson | Mississippi | 28127 | 7013 | 148 |
2442062 | 2442062 | 2022-04-25 | Simpson | Kentucky | 21213 | 5622 | 91 |
2442433 | 2442433 | 2022-04-25 | Simpson | Mississippi | 28127 | 7006 | 148 |
2438806 | 2438806 | 2022-04-24 | Simpson | Kentucky | 21213 | 5622 | 91 |
2439177 | 2439177 | 2022-04-24 | Simpson | Mississippi | 28127 | 7006 | 148 |
2435550 | 2435550 | 2022-04-23 | Simpson | Kentucky | 21213 | 5622 | 91 |
2435921 | 2435921 | 2022-04-23 | Simpson | Mississippi | 28127 | 7006 | 148 |
2432294 | 2432294 | 2022-04-22 | Simpson | Kentucky | 21213 | 5622 | 91 |
2432665 | 2432665 | 2022-04-22 | Simpson | Mississippi | 28127 | 7006 | 148 |
2429038 | 2429038 | 2022-04-21 | Simpson | Kentucky | 21213 | 5622 | 91 |
2429409 | 2429409 | 2022-04-21 | Simpson | Mississippi | 28127 | 7006 | 148 |
2425782 | 2425782 | 2022-04-20 | Simpson | Kentucky | 21213 | 5622 | 91 |
2426153 | 2426153 | 2022-04-20 | Simpson | Mississippi | 28127 | 7006 | 148 |
2422526 | 2422526 | 2022-04-19 | Simpson | Kentucky | 21213 | 5622 | 91 |
2422897 | 2422897 | 2022-04-19 | Simpson | Mississippi | 28127 | 7006 | 148 |
2419270 | 2419270 | 2022-04-18 | Simpson | Kentucky | 21213 | 5622 | 91 |
2419641 | 2419641 | 2022-04-18 | Simpson | Mississippi | 28127 | 7006 | 148 |
2416014 | 2416014 | 2022-04-17 | Simpson | Kentucky | 21213 | 5610 | 90 |
2416385 | 2416385 | 2022-04-17 | Simpson | Mississippi | 28127 | 7000 | 148 |
2412758 | 2412758 | 2022-04-16 | Simpson | Kentucky | 21213 | 5610 | 90 |
2413129 | 2413129 | 2022-04-16 | Simpson | Mississippi | 28127 | 7000 | 148 |
2409502 | 2409502 | 2022-04-15 | Simpson | Kentucky | 21213 | 5610 | 90 |
2409873 | 2409873 | 2022-04-15 | Simpson | Mississippi | 28127 | 7000 | 148 |
2406246 | 2406246 | 2022-04-14 | Simpson | Kentucky | 21213 | 5610 | 90 |
2406617 | 2406617 | 2022-04-14 | Simpson | Mississippi | 28127 | 7000 | 148 |
2402990 | 2402990 | 2022-04-13 | Simpson | Kentucky | 21213 | 5610 | 90 |
2403361 | 2403361 | 2022-04-13 | Simpson | Mississippi | 28127 | 7000 | 148 |
2399736 | 2399736 | 2022-04-12 | Simpson | Kentucky | 21213 | 5610 | 90 |
2400107 | 2400107 | 2022-04-12 | Simpson | Mississippi | 28127 | 7000 | 148 |
2396480 | 2396480 | 2022-04-11 | Simpson | Kentucky | 21213 | 5610 | 90 |
2396851 | 2396851 | 2022-04-11 | Simpson | Mississippi | 28127 | 6988 | 148 |
2393225 | 2393225 | 2022-04-10 | Simpson | Kentucky | 21213 | 5611 | 89 |
2393596 | 2393596 | 2022-04-10 | Simpson | Mississippi | 28127 | 6988 | 148 |
2389969 | 2389969 | 2022-04-09 | Simpson | Kentucky | 21213 | 5611 | 89 |
2390340 | 2390340 | 2022-04-09 | Simpson | Mississippi | 28127 | 6988 | 148 |
2386713 | 2386713 | 2022-04-08 | Simpson | Kentucky | 21213 | 5611 | 89 |
2387084 | 2387084 | 2022-04-08 | Simpson | Mississippi | 28127 | 6988 | 148 |
2383458 | 2383458 | 2022-04-07 | Simpson | Kentucky | 21213 | 5611 | 89 |
2383829 | 2383829 | 2022-04-07 | Simpson | Mississippi | 28127 | 6988 | 148 |
2380203 | 2380203 | 2022-04-06 | Simpson | Kentucky | 21213 | 5611 | 89 |
2380574 | 2380574 | 2022-04-06 | Simpson | Mississippi | 28127 | 6988 | 148 |
2376948 | 2376948 | 2022-04-05 | Simpson | Kentucky | 21213 | 5611 | 89 |
2377319 | 2377319 | 2022-04-05 | Simpson | Mississippi | 28127 | 6988 | 148 |
2373696 | 2373696 | 2022-04-04 | Simpson | Kentucky | 21213 | 5611 | 89 |
2374067 | 2374067 | 2022-04-04 | Simpson | Mississippi | 28127 | 6988 | 148 |
2370443 | 2370443 | 2022-04-03 | Simpson | Kentucky | 21213 | 5612 | 89 |
2370814 | 2370814 | 2022-04-03 | Simpson | Mississippi | 28127 | 6978 | 148 |
2367190 | 2367190 | 2022-04-02 | Simpson | Kentucky | 21213 | 5612 | 89 |
2367561 | 2367561 | 2022-04-02 | Simpson | Mississippi | 28127 | 6978 | 148 |
2363937 | 2363937 | 2022-04-01 | Simpson | Kentucky | 21213 | 5612 | 89 |
2364308 | 2364308 | 2022-04-01 | Simpson | Mississippi | 28127 | 6978 | 148 |
2360683 | 2360683 | 2022-03-31 | Simpson | Kentucky | 21213 | 5612 | 89 |
2361054 | 2361054 | 2022-03-31 | Simpson | Mississippi | 28127 | 6978 | 148 |
2357429 | 2357429 | 2022-03-30 | Simpson | Kentucky | 21213 | 5612 | 89 |
2357800 | 2357800 | 2022-03-30 | Simpson | Mississippi | 28127 | 6978 | 148 |
2354176 | 2354176 | 2022-03-29 | Simpson | Kentucky | 21213 | 5612 | 89 |
2354547 | 2354547 | 2022-03-29 | Simpson | Mississippi | 28127 | 6978 | 148 |
2350924 | 2350924 | 2022-03-28 | Simpson | Kentucky | 21213 | 5612 | 89 |
2351295 | 2351295 | 2022-03-28 | Simpson | Mississippi | 28127 | 6978 | 148 |
2347671 | 2347671 | 2022-03-27 | Simpson | Kentucky | 21213 | 5610 | 89 |
2348042 | 2348042 | 2022-03-27 | Simpson | Mississippi | 28127 | 6966 | 147 |
2344418 | 2344418 | 2022-03-26 | Simpson | Kentucky | 21213 | 5610 | 89 |
2344789 | 2344789 | 2022-03-26 | Simpson | Mississippi | 28127 | 6966 | 147 |
2341165 | 2341165 | 2022-03-25 | Simpson | Kentucky | 21213 | 5610 | 89 |
2341536 | 2341536 | 2022-03-25 | Simpson | Mississippi | 28127 | 6966 | 147 |
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);