ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,514 rows where county = "Emmet" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500404 | 2500404 | 2022-05-13 | Emmet | Iowa | 19063 | 2365 | 52 |
2500844 | 2500844 | 2022-05-13 | Emmet | Michigan | 26047 | 6608 | 87 |
2497146 | 2497146 | 2022-05-12 | Emmet | Iowa | 19063 | 2365 | 52 |
2497586 | 2497586 | 2022-05-12 | Emmet | Michigan | 26047 | 6608 | 87 |
2493888 | 2493888 | 2022-05-11 | Emmet | Iowa | 19063 | 2365 | 52 |
2494328 | 2494328 | 2022-05-11 | Emmet | Michigan | 26047 | 6574 | 87 |
2490630 | 2490630 | 2022-05-10 | Emmet | Iowa | 19063 | 2364 | 52 |
2491070 | 2491070 | 2022-05-10 | Emmet | Michigan | 26047 | 6574 | 87 |
2487373 | 2487373 | 2022-05-09 | Emmet | Iowa | 19063 | 2364 | 52 |
2487813 | 2487813 | 2022-05-09 | Emmet | Michigan | 26047 | 6502 | 87 |
2484115 | 2484115 | 2022-05-08 | Emmet | Iowa | 19063 | 2364 | 52 |
2484555 | 2484555 | 2022-05-08 | Emmet | Michigan | 26047 | 6502 | 87 |
2480857 | 2480857 | 2022-05-07 | Emmet | Iowa | 19063 | 2364 | 52 |
2481297 | 2481297 | 2022-05-07 | Emmet | Michigan | 26047 | 6502 | 87 |
2477599 | 2477599 | 2022-05-06 | Emmet | Iowa | 19063 | 2364 | 52 |
2478039 | 2478039 | 2022-05-06 | Emmet | Michigan | 26047 | 6502 | 87 |
2474341 | 2474341 | 2022-05-05 | Emmet | Iowa | 19063 | 2364 | 52 |
2474781 | 2474781 | 2022-05-05 | Emmet | Michigan | 26047 | 6502 | 87 |
2471084 | 2471084 | 2022-05-04 | Emmet | Iowa | 19063 | 2364 | 52 |
2471524 | 2471524 | 2022-05-04 | Emmet | Michigan | 26047 | 6484 | 86 |
2467828 | 2467828 | 2022-05-03 | Emmet | Iowa | 19063 | 2355 | 52 |
2468268 | 2468268 | 2022-05-03 | Emmet | Michigan | 26047 | 6484 | 86 |
2464573 | 2464573 | 2022-05-02 | Emmet | Iowa | 19063 | 2355 | 52 |
2465013 | 2465013 | 2022-05-02 | Emmet | Michigan | 26047 | 6460 | 86 |
2461317 | 2461317 | 2022-05-01 | Emmet | Iowa | 19063 | 2355 | 52 |
2461757 | 2461757 | 2022-05-01 | Emmet | Michigan | 26047 | 6460 | 86 |
2458061 | 2458061 | 2022-04-30 | Emmet | Iowa | 19063 | 2355 | 52 |
2458501 | 2458501 | 2022-04-30 | Emmet | Michigan | 26047 | 6460 | 86 |
2454805 | 2454805 | 2022-04-29 | Emmet | Iowa | 19063 | 2355 | 52 |
2455245 | 2455245 | 2022-04-29 | Emmet | Michigan | 26047 | 6460 | 86 |
2451549 | 2451549 | 2022-04-28 | Emmet | Iowa | 19063 | 2355 | 52 |
2451989 | 2451989 | 2022-04-28 | Emmet | Michigan | 26047 | 6455 | 86 |
2448293 | 2448293 | 2022-04-27 | Emmet | Iowa | 19063 | 2355 | 52 |
2448733 | 2448733 | 2022-04-27 | Emmet | Michigan | 26047 | 6443 | 86 |
2445037 | 2445037 | 2022-04-26 | Emmet | Iowa | 19063 | 2353 | 52 |
2445477 | 2445477 | 2022-04-26 | Emmet | Michigan | 26047 | 6423 | 86 |
2441781 | 2441781 | 2022-04-25 | Emmet | Iowa | 19063 | 2353 | 52 |
2442221 | 2442221 | 2022-04-25 | Emmet | Michigan | 26047 | 6423 | 86 |
2438525 | 2438525 | 2022-04-24 | Emmet | Iowa | 19063 | 2353 | 52 |
2438965 | 2438965 | 2022-04-24 | Emmet | Michigan | 26047 | 6423 | 86 |
2435269 | 2435269 | 2022-04-23 | Emmet | Iowa | 19063 | 2353 | 52 |
2435709 | 2435709 | 2022-04-23 | Emmet | Michigan | 26047 | 6423 | 86 |
2432013 | 2432013 | 2022-04-22 | Emmet | Iowa | 19063 | 2353 | 52 |
2432453 | 2432453 | 2022-04-22 | Emmet | Michigan | 26047 | 6423 | 86 |
2428757 | 2428757 | 2022-04-21 | Emmet | Iowa | 19063 | 2353 | 52 |
2429197 | 2429197 | 2022-04-21 | Emmet | Michigan | 26047 | 6423 | 86 |
2425501 | 2425501 | 2022-04-20 | Emmet | Iowa | 19063 | 2353 | 52 |
2425941 | 2425941 | 2022-04-20 | Emmet | Michigan | 26047 | 6405 | 86 |
2422245 | 2422245 | 2022-04-19 | Emmet | Iowa | 19063 | 2353 | 51 |
2422685 | 2422685 | 2022-04-19 | Emmet | Michigan | 26047 | 6405 | 86 |
2418989 | 2418989 | 2022-04-18 | Emmet | Iowa | 19063 | 2353 | 51 |
2419429 | 2419429 | 2022-04-18 | Emmet | Michigan | 26047 | 6391 | 86 |
2415733 | 2415733 | 2022-04-17 | Emmet | Iowa | 19063 | 2353 | 51 |
2416173 | 2416173 | 2022-04-17 | Emmet | Michigan | 26047 | 6391 | 86 |
2412477 | 2412477 | 2022-04-16 | Emmet | Iowa | 19063 | 2353 | 51 |
2412917 | 2412917 | 2022-04-16 | Emmet | Michigan | 26047 | 6391 | 86 |
2409221 | 2409221 | 2022-04-15 | Emmet | Iowa | 19063 | 2353 | 51 |
2409661 | 2409661 | 2022-04-15 | Emmet | Michigan | 26047 | 6391 | 86 |
2405965 | 2405965 | 2022-04-14 | Emmet | Iowa | 19063 | 2353 | 51 |
2406405 | 2406405 | 2022-04-14 | Emmet | Michigan | 26047 | 6391 | 86 |
2402709 | 2402709 | 2022-04-13 | Emmet | Iowa | 19063 | 2353 | 51 |
2403149 | 2403149 | 2022-04-13 | Emmet | Michigan | 26047 | 6388 | 86 |
2399455 | 2399455 | 2022-04-12 | Emmet | Iowa | 19063 | 2351 | 51 |
2399895 | 2399895 | 2022-04-12 | Emmet | Michigan | 26047 | 6388 | 86 |
2396199 | 2396199 | 2022-04-11 | Emmet | Iowa | 19063 | 2351 | 51 |
2396639 | 2396639 | 2022-04-11 | Emmet | Michigan | 26047 | 6376 | 86 |
2392944 | 2392944 | 2022-04-10 | Emmet | Iowa | 19063 | 2351 | 51 |
2393384 | 2393384 | 2022-04-10 | Emmet | Michigan | 26047 | 6376 | 86 |
2389688 | 2389688 | 2022-04-09 | Emmet | Iowa | 19063 | 2351 | 51 |
2390128 | 2390128 | 2022-04-09 | Emmet | Michigan | 26047 | 6376 | 86 |
2386432 | 2386432 | 2022-04-08 | Emmet | Iowa | 19063 | 2351 | 51 |
2386872 | 2386872 | 2022-04-08 | Emmet | Michigan | 26047 | 6376 | 86 |
2383178 | 2383178 | 2022-04-07 | Emmet | Iowa | 19063 | 2351 | 51 |
2383617 | 2383617 | 2022-04-07 | Emmet | Michigan | 26047 | 6376 | 86 |
2379923 | 2379923 | 2022-04-06 | Emmet | Iowa | 19063 | 2351 | 51 |
2380362 | 2380362 | 2022-04-06 | Emmet | Michigan | 26047 | 6373 | 86 |
2376668 | 2376668 | 2022-04-05 | Emmet | Iowa | 19063 | 2351 | 51 |
2377107 | 2377107 | 2022-04-05 | Emmet | Michigan | 26047 | 6373 | 86 |
2373416 | 2373416 | 2022-04-04 | Emmet | Iowa | 19063 | 2351 | 51 |
2373855 | 2373855 | 2022-04-04 | Emmet | Michigan | 26047 | 6366 | 86 |
2370163 | 2370163 | 2022-04-03 | Emmet | Iowa | 19063 | 2351 | 51 |
2370602 | 2370602 | 2022-04-03 | Emmet | Michigan | 26047 | 6366 | 86 |
2366910 | 2366910 | 2022-04-02 | Emmet | Iowa | 19063 | 2351 | 51 |
2367349 | 2367349 | 2022-04-02 | Emmet | Michigan | 26047 | 6366 | 86 |
2363657 | 2363657 | 2022-04-01 | Emmet | Iowa | 19063 | 2351 | 51 |
2364096 | 2364096 | 2022-04-01 | Emmet | Michigan | 26047 | 6366 | 86 |
2360403 | 2360403 | 2022-03-31 | Emmet | Iowa | 19063 | 2351 | 51 |
2360842 | 2360842 | 2022-03-31 | Emmet | Michigan | 26047 | 6365 | 86 |
2357149 | 2357149 | 2022-03-30 | Emmet | Iowa | 19063 | 2351 | 51 |
2357588 | 2357588 | 2022-03-30 | Emmet | Michigan | 26047 | 6365 | 86 |
2353896 | 2353896 | 2022-03-29 | Emmet | Iowa | 19063 | 2348 | 51 |
2354335 | 2354335 | 2022-03-29 | Emmet | Michigan | 26047 | 6365 | 86 |
2350644 | 2350644 | 2022-03-28 | Emmet | Iowa | 19063 | 2348 | 51 |
2351083 | 2351083 | 2022-03-28 | Emmet | Michigan | 26047 | 6364 | 86 |
2347391 | 2347391 | 2022-03-27 | Emmet | Iowa | 19063 | 2348 | 51 |
2347830 | 2347830 | 2022-03-27 | Emmet | Michigan | 26047 | 6364 | 86 |
2344138 | 2344138 | 2022-03-26 | Emmet | Iowa | 19063 | 2348 | 51 |
2344577 | 2344577 | 2022-03-26 | Emmet | Michigan | 26047 | 6364 | 86 |
2340885 | 2340885 | 2022-03-25 | Emmet | Iowa | 19063 | 2348 | 51 |
2341324 | 2341324 | 2022-03-25 | Emmet | Michigan | 26047 | 6364 | 86 |
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);