ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,559 rows where county = "Berrien" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337204 | 2337204 | 2022-03-24 | Berrien | Georgia | 13019 | 4922 | 81 |
2338058 | 2338058 | 2022-03-24 | Berrien | Michigan | 26021 | 34571 | 542 |
2333950 | 2333950 | 2022-03-23 | Berrien | Georgia | 13019 | 4920 | 81 |
2334804 | 2334804 | 2022-03-23 | Berrien | Michigan | 26021 | 34571 | 542 |
2330696 | 2330696 | 2022-03-22 | Berrien | Georgia | 13019 | 4920 | 81 |
2331550 | 2331550 | 2022-03-22 | Berrien | Michigan | 26021 | 34564 | 539 |
2327444 | 2327444 | 2022-03-21 | Berrien | Georgia | 13019 | 4918 | 81 |
2328298 | 2328298 | 2022-03-21 | Berrien | Michigan | 26021 | 34564 | 539 |
2324191 | 2324191 | 2022-03-20 | Berrien | Georgia | 13019 | 4916 | 81 |
2325045 | 2325045 | 2022-03-20 | Berrien | Michigan | 26021 | 34541 | 539 |
2320937 | 2320937 | 2022-03-19 | Berrien | Georgia | 13019 | 4916 | 81 |
2321791 | 2321791 | 2022-03-19 | Berrien | Michigan | 26021 | 34541 | 539 |
2317683 | 2317683 | 2022-03-18 | Berrien | Georgia | 13019 | 4916 | 81 |
2318537 | 2318537 | 2022-03-18 | Berrien | Michigan | 26021 | 34541 | 539 |
2314430 | 2314430 | 2022-03-17 | Berrien | Georgia | 13019 | 4916 | 81 |
2315284 | 2315284 | 2022-03-17 | Berrien | Michigan | 26021 | 34517 | 538 |
2311177 | 2311177 | 2022-03-16 | Berrien | Georgia | 13019 | 4914 | 81 |
2312031 | 2312031 | 2022-03-16 | Berrien | Michigan | 26021 | 34517 | 538 |
2307924 | 2307924 | 2022-03-15 | Berrien | Georgia | 13019 | 4914 | 80 |
2308778 | 2308778 | 2022-03-15 | Berrien | Michigan | 26021 | 34497 | 536 |
2304673 | 2304673 | 2022-03-14 | Berrien | Georgia | 13019 | 4913 | 80 |
2305527 | 2305527 | 2022-03-14 | Berrien | Michigan | 26021 | 34497 | 536 |
2301421 | 2301421 | 2022-03-13 | Berrien | Georgia | 13019 | 4913 | 80 |
2302275 | 2302275 | 2022-03-13 | Berrien | Michigan | 26021 | 34476 | 535 |
2298169 | 2298169 | 2022-03-12 | Berrien | Georgia | 13019 | 4913 | 80 |
2299023 | 2299023 | 2022-03-12 | Berrien | Michigan | 26021 | 34476 | 535 |
2294917 | 2294917 | 2022-03-11 | Berrien | Georgia | 13019 | 4913 | 80 |
2295771 | 2295771 | 2022-03-11 | Berrien | Michigan | 26021 | 34476 | 535 |
2291665 | 2291665 | 2022-03-10 | Berrien | Georgia | 13019 | 4912 | 80 |
2292519 | 2292519 | 2022-03-10 | Berrien | Michigan | 26021 | 34461 | 534 |
2288413 | 2288413 | 2022-03-09 | Berrien | Georgia | 13019 | 4910 | 79 |
2289267 | 2289267 | 2022-03-09 | Berrien | Michigan | 26021 | 34461 | 534 |
2285162 | 2285162 | 2022-03-08 | Berrien | Georgia | 13019 | 4908 | 79 |
2286016 | 2286016 | 2022-03-08 | Berrien | Michigan | 26021 | 34441 | 529 |
2281910 | 2281910 | 2022-03-07 | Berrien | Georgia | 13019 | 4908 | 79 |
2282764 | 2282764 | 2022-03-07 | Berrien | Michigan | 26021 | 34441 | 529 |
2278657 | 2278657 | 2022-03-06 | Berrien | Georgia | 13019 | 4908 | 78 |
2279511 | 2279511 | 2022-03-06 | Berrien | Michigan | 26021 | 34411 | 529 |
2275404 | 2275404 | 2022-03-05 | Berrien | Georgia | 13019 | 4908 | 78 |
2276258 | 2276258 | 2022-03-05 | Berrien | Michigan | 26021 | 34411 | 529 |
2272151 | 2272151 | 2022-03-04 | Berrien | Georgia | 13019 | 4908 | 78 |
2273005 | 2273005 | 2022-03-04 | Berrien | Michigan | 26021 | 34411 | 529 |
2268899 | 2268899 | 2022-03-03 | Berrien | Georgia | 13019 | 4908 | 78 |
2269753 | 2269753 | 2022-03-03 | Berrien | Michigan | 26021 | 34393 | 528 |
2265646 | 2265646 | 2022-03-02 | Berrien | Georgia | 13019 | 4908 | 78 |
2266500 | 2266500 | 2022-03-02 | Berrien | Michigan | 26021 | 34393 | 528 |
2262395 | 2262395 | 2022-03-01 | Berrien | Georgia | 13019 | 4907 | 78 |
2263249 | 2263249 | 2022-03-01 | Berrien | Michigan | 26021 | 34368 | 521 |
2259144 | 2259144 | 2022-02-28 | Berrien | Georgia | 13019 | 4907 | 78 |
2259998 | 2259998 | 2022-02-28 | Berrien | Michigan | 26021 | 34368 | 521 |
2255893 | 2255893 | 2022-02-27 | Berrien | Georgia | 13019 | 4904 | 76 |
2256747 | 2256747 | 2022-02-27 | Berrien | Michigan | 26021 | 34354 | 521 |
2252642 | 2252642 | 2022-02-26 | Berrien | Georgia | 13019 | 4904 | 76 |
2253496 | 2253496 | 2022-02-26 | Berrien | Michigan | 26021 | 34354 | 521 |
2249391 | 2249391 | 2022-02-25 | Berrien | Georgia | 13019 | 4904 | 76 |
2250245 | 2250245 | 2022-02-25 | Berrien | Michigan | 26021 | 34354 | 521 |
2246140 | 2246140 | 2022-02-24 | Berrien | Georgia | 13019 | 4903 | 76 |
2246994 | 2246994 | 2022-02-24 | Berrien | Michigan | 26021 | 34314 | 517 |
2242889 | 2242889 | 2022-02-23 | Berrien | Georgia | 13019 | 4901 | 76 |
2243743 | 2243743 | 2022-02-23 | Berrien | Michigan | 26021 | 34314 | 517 |
2239638 | 2239638 | 2022-02-22 | Berrien | Georgia | 13019 | 4900 | 75 |
2240492 | 2240492 | 2022-02-22 | Berrien | Michigan | 26021 | 34245 | 513 |
2236387 | 2236387 | 2022-02-21 | Berrien | Georgia | 13019 | 4899 | 75 |
2237241 | 2237241 | 2022-02-21 | Berrien | Michigan | 26021 | 34245 | 513 |
2233136 | 2233136 | 2022-02-20 | Berrien | Georgia | 13019 | 4895 | 74 |
2233990 | 2233990 | 2022-02-20 | Berrien | Michigan | 26021 | 34245 | 513 |
2229885 | 2229885 | 2022-02-19 | Berrien | Georgia | 13019 | 4895 | 74 |
2230739 | 2230739 | 2022-02-19 | Berrien | Michigan | 26021 | 34197 | 509 |
2226634 | 2226634 | 2022-02-18 | Berrien | Georgia | 13019 | 4895 | 74 |
2227488 | 2227488 | 2022-02-18 | Berrien | Michigan | 26021 | 34197 | 509 |
2223383 | 2223383 | 2022-02-17 | Berrien | Georgia | 13019 | 4891 | 74 |
2224237 | 2224237 | 2022-02-17 | Berrien | Michigan | 26021 | 34197 | 509 |
2220132 | 2220132 | 2022-02-16 | Berrien | Georgia | 13019 | 4889 | 74 |
2220986 | 2220986 | 2022-02-16 | Berrien | Michigan | 26021 | 34197 | 509 |
2216881 | 2216881 | 2022-02-15 | Berrien | Georgia | 13019 | 4888 | 74 |
2217735 | 2217735 | 2022-02-15 | Berrien | Michigan | 26021 | 34146 | 498 |
2213630 | 2213630 | 2022-02-14 | Berrien | Georgia | 13019 | 4887 | 74 |
2214484 | 2214484 | 2022-02-14 | Berrien | Michigan | 26021 | 34146 | 498 |
2210378 | 2210378 | 2022-02-13 | Berrien | Georgia | 13019 | 4881 | 74 |
2211232 | 2211232 | 2022-02-13 | Berrien | Michigan | 26021 | 34072 | 498 |
2207125 | 2207125 | 2022-02-12 | Berrien | Georgia | 13019 | 4881 | 74 |
2207979 | 2207979 | 2022-02-12 | Berrien | Michigan | 26021 | 34072 | 498 |
2203872 | 2203872 | 2022-02-11 | Berrien | Georgia | 13019 | 4881 | 74 |
2204726 | 2204726 | 2022-02-11 | Berrien | Michigan | 26021 | 34072 | 498 |
2200619 | 2200619 | 2022-02-10 | Berrien | Georgia | 13019 | 4875 | 73 |
2201473 | 2201473 | 2022-02-10 | Berrien | Michigan | 26021 | 33963 | 494 |
2197365 | 2197365 | 2022-02-09 | Berrien | Georgia | 13019 | 4861 | 73 |
2198219 | 2198219 | 2022-02-09 | Berrien | Michigan | 26021 | 33963 | 494 |
2194111 | 2194111 | 2022-02-08 | Berrien | Georgia | 13019 | 4849 | 73 |
2194965 | 2194965 | 2022-02-08 | Berrien | Michigan | 26021 | 33794 | 481 |
2190857 | 2190857 | 2022-02-07 | Berrien | Georgia | 13019 | 4838 | 72 |
2191711 | 2191711 | 2022-02-07 | Berrien | Michigan | 26021 | 33794 | 481 |
2187604 | 2187604 | 2022-02-06 | Berrien | Georgia | 13019 | 4818 | 72 |
2188458 | 2188458 | 2022-02-06 | Berrien | Michigan | 26021 | 33672 | 481 |
2184351 | 2184351 | 2022-02-05 | Berrien | Georgia | 13019 | 4818 | 72 |
2185205 | 2185205 | 2022-02-05 | Berrien | Michigan | 26021 | 33672 | 481 |
2181099 | 2181099 | 2022-02-04 | Berrien | Georgia | 13019 | 4818 | 72 |
2181953 | 2181953 | 2022-02-04 | Berrien | Michigan | 26021 | 33672 | 481 |
2177848 | 2177848 | 2022-02-03 | Berrien | Georgia | 13019 | 4804 | 72 |
2178701 | 2178701 | 2022-02-03 | Berrien | Michigan | 26021 | 33538 | 478 |
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);