ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,348 rows where county = "Miami" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Miami · 2,248 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2393073 | 2393073 | 2022-04-10 | Miami | Kansas | 20121 | 7732 | 93 |
2394238 | 2394238 | 2022-04-10 | Miami | Ohio | 39109 | 25702 | 480 |
2389615 | 2389615 | 2022-04-09 | Miami | Indiana | 18103 | 9253 | 159 |
2389817 | 2389817 | 2022-04-09 | Miami | Kansas | 20121 | 7732 | 93 |
2390982 | 2390982 | 2022-04-09 | Miami | Ohio | 39109 | 25702 | 480 |
2386360 | 2386360 | 2022-04-08 | Miami | Indiana | 18103 | 9253 | 159 |
2386561 | 2386561 | 2022-04-08 | Miami | Kansas | 20121 | 7732 | 93 |
2387726 | 2387726 | 2022-04-08 | Miami | Ohio | 39109 | 25702 | 480 |
2383105 | 2383105 | 2022-04-07 | Miami | Indiana | 18103 | 9252 | 159 |
2383307 | 2383307 | 2022-04-07 | Miami | Kansas | 20121 | 7729 | 93 |
2384471 | 2384471 | 2022-04-07 | Miami | Ohio | 39109 | 25702 | 480 |
2379850 | 2379850 | 2022-04-06 | Miami | Indiana | 18103 | 9252 | 159 |
2380052 | 2380052 | 2022-04-06 | Miami | Kansas | 20121 | 7729 | 93 |
2381216 | 2381216 | 2022-04-06 | Miami | Ohio | 39109 | 25692 | 476 |
2376596 | 2376596 | 2022-04-05 | Miami | Indiana | 18103 | 9251 | 159 |
2376797 | 2376797 | 2022-04-05 | Miami | Kansas | 20121 | 7729 | 93 |
2377961 | 2377961 | 2022-04-05 | Miami | Ohio | 39109 | 25692 | 476 |
2373344 | 2373344 | 2022-04-04 | Miami | Indiana | 18103 | 9251 | 159 |
2373545 | 2373545 | 2022-04-04 | Miami | Kansas | 20121 | 7729 | 93 |
2374707 | 2374707 | 2022-04-04 | Miami | Ohio | 39109 | 25692 | 476 |
2370091 | 2370091 | 2022-04-03 | Miami | Indiana | 18103 | 9251 | 159 |
2370292 | 2370292 | 2022-04-03 | Miami | Kansas | 20121 | 7729 | 93 |
2371455 | 2371455 | 2022-04-03 | Miami | Ohio | 39109 | 25692 | 476 |
2366838 | 2366838 | 2022-04-02 | Miami | Indiana | 18103 | 9251 | 159 |
2367039 | 2367039 | 2022-04-02 | Miami | Kansas | 20121 | 7729 | 93 |
2368202 | 2368202 | 2022-04-02 | Miami | Ohio | 39109 | 25692 | 476 |
2363585 | 2363585 | 2022-04-01 | Miami | Indiana | 18103 | 9251 | 159 |
2363786 | 2363786 | 2022-04-01 | Miami | Kansas | 20121 | 7729 | 93 |
2364949 | 2364949 | 2022-04-01 | Miami | Ohio | 39109 | 25692 | 476 |
2360331 | 2360331 | 2022-03-31 | Miami | Indiana | 18103 | 9248 | 159 |
2360532 | 2360532 | 2022-03-31 | Miami | Kansas | 20121 | 7728 | 93 |
2361696 | 2361696 | 2022-03-31 | Miami | Ohio | 39109 | 25692 | 476 |
2357077 | 2357077 | 2022-03-30 | Miami | Indiana | 18103 | 9248 | 159 |
2357278 | 2357278 | 2022-03-30 | Miami | Kansas | 20121 | 7728 | 93 |
2358442 | 2358442 | 2022-03-30 | Miami | Ohio | 39109 | 25682 | 473 |
2353824 | 2353824 | 2022-03-29 | Miami | Indiana | 18103 | 9261 | 159 |
2354025 | 2354025 | 2022-03-29 | Miami | Kansas | 20121 | 7723 | 91 |
2355188 | 2355188 | 2022-03-29 | Miami | Ohio | 39109 | 25682 | 473 |
2350572 | 2350572 | 2022-03-28 | Miami | Indiana | 18103 | 9259 | 159 |
2350773 | 2350773 | 2022-03-28 | Miami | Kansas | 20121 | 7723 | 91 |
2351935 | 2351935 | 2022-03-28 | Miami | Ohio | 39109 | 25682 | 473 |
2347319 | 2347319 | 2022-03-27 | Miami | Indiana | 18103 | 9258 | 159 |
2347520 | 2347520 | 2022-03-27 | Miami | Kansas | 20121 | 7721 | 91 |
2348683 | 2348683 | 2022-03-27 | Miami | Ohio | 39109 | 25682 | 473 |
2344066 | 2344066 | 2022-03-26 | Miami | Indiana | 18103 | 9258 | 159 |
2344267 | 2344267 | 2022-03-26 | Miami | Kansas | 20121 | 7721 | 91 |
2345430 | 2345430 | 2022-03-26 | Miami | Ohio | 39109 | 25682 | 473 |
2340813 | 2340813 | 2022-03-25 | Miami | Indiana | 18103 | 9258 | 159 |
2341014 | 2341014 | 2022-03-25 | Miami | Kansas | 20121 | 7721 | 91 |
2342177 | 2342177 | 2022-03-25 | Miami | Ohio | 39109 | 25682 | 473 |
2337560 | 2337560 | 2022-03-24 | Miami | Indiana | 18103 | 9255 | 159 |
2337761 | 2337761 | 2022-03-24 | Miami | Kansas | 20121 | 7720 | 90 |
2338924 | 2338924 | 2022-03-24 | Miami | Ohio | 39109 | 25682 | 473 |
2334306 | 2334306 | 2022-03-23 | Miami | Indiana | 18103 | 9255 | 159 |
2334507 | 2334507 | 2022-03-23 | Miami | Kansas | 20121 | 7720 | 90 |
2335670 | 2335670 | 2022-03-23 | Miami | Ohio | 39109 | 25671 | 473 |
2331052 | 2331052 | 2022-03-22 | Miami | Indiana | 18103 | 9252 | 158 |
2331253 | 2331253 | 2022-03-22 | Miami | Kansas | 20121 | 7717 | 90 |
2332416 | 2332416 | 2022-03-22 | Miami | Ohio | 39109 | 25671 | 473 |
2327800 | 2327800 | 2022-03-21 | Miami | Indiana | 18103 | 9252 | 158 |
2328001 | 2328001 | 2022-03-21 | Miami | Kansas | 20121 | 7717 | 90 |
2329163 | 2329163 | 2022-03-21 | Miami | Ohio | 39109 | 25671 | 473 |
2324547 | 2324547 | 2022-03-20 | Miami | Indiana | 18103 | 9252 | 158 |
2324748 | 2324748 | 2022-03-20 | Miami | Kansas | 20121 | 7714 | 90 |
2325911 | 2325911 | 2022-03-20 | Miami | Ohio | 39109 | 25671 | 473 |
2321293 | 2321293 | 2022-03-19 | Miami | Indiana | 18103 | 9252 | 158 |
2321494 | 2321494 | 2022-03-19 | Miami | Kansas | 20121 | 7714 | 90 |
2322658 | 2322658 | 2022-03-19 | Miami | Ohio | 39109 | 25671 | 473 |
2318039 | 2318039 | 2022-03-18 | Miami | Indiana | 18103 | 9252 | 158 |
2318240 | 2318240 | 2022-03-18 | Miami | Kansas | 20121 | 7714 | 90 |
2319404 | 2319404 | 2022-03-18 | Miami | Ohio | 39109 | 25671 | 473 |
2314786 | 2314786 | 2022-03-17 | Miami | Indiana | 18103 | 9248 | 158 |
2314987 | 2314987 | 2022-03-17 | Miami | Kansas | 20121 | 7709 | 87 |
2316150 | 2316150 | 2022-03-17 | Miami | Ohio | 39109 | 25671 | 473 |
2311533 | 2311533 | 2022-03-16 | Miami | Indiana | 18103 | 9246 | 158 |
2311734 | 2311734 | 2022-03-16 | Miami | Kansas | 20121 | 7709 | 87 |
2312897 | 2312897 | 2022-03-16 | Miami | Ohio | 39109 | 25664 | 472 |
2308280 | 2308280 | 2022-03-15 | Miami | Indiana | 18103 | 9243 | 158 |
2308481 | 2308481 | 2022-03-15 | Miami | Kansas | 20121 | 7704 | 87 |
2309644 | 2309644 | 2022-03-15 | Miami | Ohio | 39109 | 25664 | 472 |
2305029 | 2305029 | 2022-03-14 | Miami | Indiana | 18103 | 9239 | 158 |
2305230 | 2305230 | 2022-03-14 | Miami | Kansas | 20121 | 7704 | 87 |
2306391 | 2306391 | 2022-03-14 | Miami | Ohio | 39109 | 25664 | 472 |
2301777 | 2301777 | 2022-03-13 | Miami | Indiana | 18103 | 9237 | 158 |
2301978 | 2301978 | 2022-03-13 | Miami | Kansas | 20121 | 7700 | 87 |
2303140 | 2303140 | 2022-03-13 | Miami | Ohio | 39109 | 25664 | 472 |
2298525 | 2298525 | 2022-03-12 | Miami | Indiana | 18103 | 9237 | 158 |
2298726 | 2298726 | 2022-03-12 | Miami | Kansas | 20121 | 7700 | 87 |
2299888 | 2299888 | 2022-03-12 | Miami | Ohio | 39109 | 25663 | 472 |
2295273 | 2295273 | 2022-03-11 | Miami | Indiana | 18103 | 9237 | 158 |
2295474 | 2295474 | 2022-03-11 | Miami | Kansas | 20121 | 7700 | 87 |
2296636 | 2296636 | 2022-03-11 | Miami | Ohio | 39109 | 25659 | 472 |
2292021 | 2292021 | 2022-03-10 | Miami | Indiana | 18103 | 9234 | 158 |
2292222 | 2292222 | 2022-03-10 | Miami | Kansas | 20121 | 7699 | 87 |
2293384 | 2293384 | 2022-03-10 | Miami | Ohio | 39109 | 25653 | 470 |
2288769 | 2288769 | 2022-03-09 | Miami | Indiana | 18103 | 9232 | 158 |
2288970 | 2288970 | 2022-03-09 | Miami | Kansas | 20121 | 7699 | 87 |
2290132 | 2290132 | 2022-03-09 | Miami | Ohio | 39109 | 25653 | 470 |
2285518 | 2285518 | 2022-03-08 | Miami | Indiana | 18103 | 9231 | 158 |
2285719 | 2285719 | 2022-03-08 | Miami | Kansas | 20121 | 7698 | 87 |
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);