ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Antrim" and state = "Michigan" 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 |
---|---|---|---|---|---|---|---|
2500825 | 2500825 | 2022-05-13 | Antrim | Michigan | 26009 | 4470 | 66 |
2497567 | 2497567 | 2022-05-12 | Antrim | Michigan | 26009 | 4470 | 66 |
2494309 | 2494309 | 2022-05-11 | Antrim | Michigan | 26009 | 4449 | 66 |
2491051 | 2491051 | 2022-05-10 | Antrim | Michigan | 26009 | 4449 | 66 |
2487794 | 2487794 | 2022-05-09 | Antrim | Michigan | 26009 | 4413 | 65 |
2484536 | 2484536 | 2022-05-08 | Antrim | Michigan | 26009 | 4413 | 65 |
2481278 | 2481278 | 2022-05-07 | Antrim | Michigan | 26009 | 4413 | 65 |
2478020 | 2478020 | 2022-05-06 | Antrim | Michigan | 26009 | 4413 | 65 |
2474762 | 2474762 | 2022-05-05 | Antrim | Michigan | 26009 | 4413 | 65 |
2471505 | 2471505 | 2022-05-04 | Antrim | Michigan | 26009 | 4401 | 65 |
2468249 | 2468249 | 2022-05-03 | Antrim | Michigan | 26009 | 4401 | 65 |
2464994 | 2464994 | 2022-05-02 | Antrim | Michigan | 26009 | 4383 | 65 |
2461738 | 2461738 | 2022-05-01 | Antrim | Michigan | 26009 | 4383 | 65 |
2458482 | 2458482 | 2022-04-30 | Antrim | Michigan | 26009 | 4383 | 65 |
2455226 | 2455226 | 2022-04-29 | Antrim | Michigan | 26009 | 4383 | 65 |
2451970 | 2451970 | 2022-04-28 | Antrim | Michigan | 26009 | 4377 | 65 |
2448714 | 2448714 | 2022-04-27 | Antrim | Michigan | 26009 | 4373 | 65 |
2445458 | 2445458 | 2022-04-26 | Antrim | Michigan | 26009 | 4355 | 64 |
2442202 | 2442202 | 2022-04-25 | Antrim | Michigan | 26009 | 4355 | 64 |
2438946 | 2438946 | 2022-04-24 | Antrim | Michigan | 26009 | 4355 | 64 |
2435690 | 2435690 | 2022-04-23 | Antrim | Michigan | 26009 | 4355 | 64 |
2432434 | 2432434 | 2022-04-22 | Antrim | Michigan | 26009 | 4355 | 64 |
2429178 | 2429178 | 2022-04-21 | Antrim | Michigan | 26009 | 4355 | 64 |
2425922 | 2425922 | 2022-04-20 | Antrim | Michigan | 26009 | 4346 | 64 |
2422666 | 2422666 | 2022-04-19 | Antrim | Michigan | 26009 | 4346 | 64 |
2419410 | 2419410 | 2022-04-18 | Antrim | Michigan | 26009 | 4332 | 64 |
2416154 | 2416154 | 2022-04-17 | Antrim | Michigan | 26009 | 4332 | 64 |
2412898 | 2412898 | 2022-04-16 | Antrim | Michigan | 26009 | 4332 | 64 |
2409642 | 2409642 | 2022-04-15 | Antrim | Michigan | 26009 | 4332 | 64 |
2406386 | 2406386 | 2022-04-14 | Antrim | Michigan | 26009 | 4332 | 64 |
2403130 | 2403130 | 2022-04-13 | Antrim | Michigan | 26009 | 4325 | 64 |
2399876 | 2399876 | 2022-04-12 | Antrim | Michigan | 26009 | 4325 | 64 |
2396620 | 2396620 | 2022-04-11 | Antrim | Michigan | 26009 | 4316 | 64 |
2393365 | 2393365 | 2022-04-10 | Antrim | Michigan | 26009 | 4316 | 64 |
2390109 | 2390109 | 2022-04-09 | Antrim | Michigan | 26009 | 4316 | 64 |
2386853 | 2386853 | 2022-04-08 | Antrim | Michigan | 26009 | 4316 | 64 |
2383598 | 2383598 | 2022-04-07 | Antrim | Michigan | 26009 | 4316 | 64 |
2380343 | 2380343 | 2022-04-06 | Antrim | Michigan | 26009 | 4312 | 64 |
2377088 | 2377088 | 2022-04-05 | Antrim | Michigan | 26009 | 4312 | 64 |
2373836 | 2373836 | 2022-04-04 | Antrim | Michigan | 26009 | 4309 | 64 |
2370583 | 2370583 | 2022-04-03 | Antrim | Michigan | 26009 | 4309 | 64 |
2367330 | 2367330 | 2022-04-02 | Antrim | Michigan | 26009 | 4309 | 64 |
2364077 | 2364077 | 2022-04-01 | Antrim | Michigan | 26009 | 4309 | 64 |
2360823 | 2360823 | 2022-03-31 | Antrim | Michigan | 26009 | 4306 | 64 |
2357569 | 2357569 | 2022-03-30 | Antrim | Michigan | 26009 | 4306 | 64 |
2354316 | 2354316 | 2022-03-29 | Antrim | Michigan | 26009 | 4306 | 64 |
2351064 | 2351064 | 2022-03-28 | Antrim | Michigan | 26009 | 4303 | 64 |
2347811 | 2347811 | 2022-03-27 | Antrim | Michigan | 26009 | 4303 | 64 |
2344558 | 2344558 | 2022-03-26 | Antrim | Michigan | 26009 | 4303 | 64 |
2341305 | 2341305 | 2022-03-25 | Antrim | Michigan | 26009 | 4303 | 64 |
2338052 | 2338052 | 2022-03-24 | Antrim | Michigan | 26009 | 4303 | 64 |
2334798 | 2334798 | 2022-03-23 | Antrim | Michigan | 26009 | 4300 | 63 |
2331544 | 2331544 | 2022-03-22 | Antrim | Michigan | 26009 | 4300 | 63 |
2328292 | 2328292 | 2022-03-21 | Antrim | Michigan | 26009 | 4295 | 62 |
2325039 | 2325039 | 2022-03-20 | Antrim | Michigan | 26009 | 4294 | 62 |
2321785 | 2321785 | 2022-03-19 | Antrim | Michigan | 26009 | 4294 | 62 |
2318531 | 2318531 | 2022-03-18 | Antrim | Michigan | 26009 | 4294 | 62 |
2315278 | 2315278 | 2022-03-17 | Antrim | Michigan | 26009 | 4294 | 62 |
2312025 | 2312025 | 2022-03-16 | Antrim | Michigan | 26009 | 4291 | 62 |
2308772 | 2308772 | 2022-03-15 | Antrim | Michigan | 26009 | 4291 | 62 |
2305521 | 2305521 | 2022-03-14 | Antrim | Michigan | 26009 | 4284 | 61 |
2302269 | 2302269 | 2022-03-13 | Antrim | Michigan | 26009 | 4279 | 61 |
2299017 | 2299017 | 2022-03-12 | Antrim | Michigan | 26009 | 4279 | 61 |
2295765 | 2295765 | 2022-03-11 | Antrim | Michigan | 26009 | 4279 | 61 |
2292513 | 2292513 | 2022-03-10 | Antrim | Michigan | 26009 | 4279 | 61 |
2289261 | 2289261 | 2022-03-09 | Antrim | Michigan | 26009 | 4277 | 61 |
2286010 | 2286010 | 2022-03-08 | Antrim | Michigan | 26009 | 4277 | 61 |
2282758 | 2282758 | 2022-03-07 | Antrim | Michigan | 26009 | 4270 | 61 |
2279505 | 2279505 | 2022-03-06 | Antrim | Michigan | 26009 | 4269 | 61 |
2276252 | 2276252 | 2022-03-05 | Antrim | Michigan | 26009 | 4269 | 61 |
2272999 | 2272999 | 2022-03-04 | Antrim | Michigan | 26009 | 4269 | 61 |
2269747 | 2269747 | 2022-03-03 | Antrim | Michigan | 26009 | 4269 | 60 |
2266494 | 2266494 | 2022-03-02 | Antrim | Michigan | 26009 | 4264 | 60 |
2263243 | 2263243 | 2022-03-01 | Antrim | Michigan | 26009 | 4264 | 59 |
2259992 | 2259992 | 2022-02-28 | Antrim | Michigan | 26009 | 4261 | 58 |
2256741 | 2256741 | 2022-02-27 | Antrim | Michigan | 26009 | 4253 | 58 |
2253490 | 2253490 | 2022-02-26 | Antrim | Michigan | 26009 | 4253 | 58 |
2250239 | 2250239 | 2022-02-25 | Antrim | Michigan | 26009 | 4253 | 58 |
2246988 | 2246988 | 2022-02-24 | Antrim | Michigan | 26009 | 4249 | 58 |
2243737 | 2243737 | 2022-02-23 | Antrim | Michigan | 26009 | 4242 | 58 |
2240486 | 2240486 | 2022-02-22 | Antrim | Michigan | 26009 | 4239 | 57 |
2237235 | 2237235 | 2022-02-21 | Antrim | Michigan | 26009 | 4220 | 57 |
2233984 | 2233984 | 2022-02-20 | Antrim | Michigan | 26009 | 4220 | 57 |
2230733 | 2230733 | 2022-02-19 | Antrim | Michigan | 26009 | 4220 | 57 |
2227482 | 2227482 | 2022-02-18 | Antrim | Michigan | 26009 | 4220 | 57 |
2224231 | 2224231 | 2022-02-17 | Antrim | Michigan | 26009 | 4220 | 57 |
2220980 | 2220980 | 2022-02-16 | Antrim | Michigan | 26009 | 4211 | 57 |
2217729 | 2217729 | 2022-02-15 | Antrim | Michigan | 26009 | 4194 | 57 |
2214478 | 2214478 | 2022-02-14 | Antrim | Michigan | 26009 | 4194 | 57 |
2211226 | 2211226 | 2022-02-13 | Antrim | Michigan | 26009 | 4174 | 56 |
2207973 | 2207973 | 2022-02-12 | Antrim | Michigan | 26009 | 4174 | 56 |
2204720 | 2204720 | 2022-02-11 | Antrim | Michigan | 26009 | 4174 | 56 |
2201467 | 2201467 | 2022-02-10 | Antrim | Michigan | 26009 | 4170 | 56 |
2198213 | 2198213 | 2022-02-09 | Antrim | Michigan | 26009 | 4158 | 56 |
2194959 | 2194959 | 2022-02-08 | Antrim | Michigan | 26009 | 4153 | 55 |
2191705 | 2191705 | 2022-02-07 | Antrim | Michigan | 26009 | 4136 | 55 |
2188452 | 2188452 | 2022-02-06 | Antrim | Michigan | 26009 | 4123 | 54 |
2185199 | 2185199 | 2022-02-05 | Antrim | Michigan | 26009 | 4123 | 54 |
2181947 | 2181947 | 2022-02-04 | Antrim | Michigan | 26009 | 4123 | 54 |
2178695 | 2178695 | 2022-02-03 | Antrim | Michigan | 26009 | 4078 | 54 |
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);