ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

775 rows where county = "Berrien" and state = "Georgia" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Georgia · 775 ✖

fips 1

county 1

  • Berrien · 775 ✖
Link rowid date ▲ county state fips cases deaths
2499975 2499975 2022-05-13 Berrien Georgia 13019 4955 83
2496717 2496717 2022-05-12 Berrien Georgia 13019 4955 83
2493459 2493459 2022-05-11 Berrien Georgia 13019 4955 83
2490201 2490201 2022-05-10 Berrien Georgia 13019 4946 83
2486944 2486944 2022-05-09 Berrien Georgia 13019 4946 83
2483686 2483686 2022-05-08 Berrien Georgia 13019 4947 83
2480428 2480428 2022-05-07 Berrien Georgia 13019 4947 83
2477170 2477170 2022-05-06 Berrien Georgia 13019 4947 83
2473912 2473912 2022-05-05 Berrien Georgia 13019 4947 83
2470655 2470655 2022-05-04 Berrien Georgia 13019 4947 83
2467399 2467399 2022-05-03 Berrien Georgia 13019 4942 83
2464144 2464144 2022-05-02 Berrien Georgia 13019 4942 83
2460888 2460888 2022-05-01 Berrien Georgia 13019 4942 83
2457632 2457632 2022-04-30 Berrien Georgia 13019 4942 83
2454376 2454376 2022-04-29 Berrien Georgia 13019 4942 83
2451120 2451120 2022-04-28 Berrien Georgia 13019 4942 83
2447864 2447864 2022-04-27 Berrien Georgia 13019 4942 83
2444608 2444608 2022-04-26 Berrien Georgia 13019 4940 83
2441352 2441352 2022-04-25 Berrien Georgia 13019 4940 83
2438096 2438096 2022-04-24 Berrien Georgia 13019 4940 83
2434840 2434840 2022-04-23 Berrien Georgia 13019 4940 83
2431584 2431584 2022-04-22 Berrien Georgia 13019 4940 83
2428328 2428328 2022-04-21 Berrien Georgia 13019 4940 83
2425072 2425072 2022-04-20 Berrien Georgia 13019 4940 83
2421816 2421816 2022-04-19 Berrien Georgia 13019 4937 82
2418560 2418560 2022-04-18 Berrien Georgia 13019 4937 82
2415304 2415304 2022-04-17 Berrien Georgia 13019 4937 82
2412048 2412048 2022-04-16 Berrien Georgia 13019 4937 82
2408792 2408792 2022-04-15 Berrien Georgia 13019 4937 82
2405536 2405536 2022-04-14 Berrien Georgia 13019 4937 82
2402281 2402281 2022-04-13 Berrien Georgia 13019 4937 82
2399026 2399026 2022-04-12 Berrien Georgia 13019 4936 82
2395771 2395771 2022-04-11 Berrien Georgia 13019 4936 82
2392515 2392515 2022-04-10 Berrien Georgia 13019 4936 82
2389259 2389259 2022-04-09 Berrien Georgia 13019 4936 82
2386004 2386004 2022-04-08 Berrien Georgia 13019 4936 82
2382749 2382749 2022-04-07 Berrien Georgia 13019 4935 82
2379494 2379494 2022-04-06 Berrien Georgia 13019 4935 82
2376240 2376240 2022-04-05 Berrien Georgia 13019 4934 82
2372988 2372988 2022-04-04 Berrien Georgia 13019 4934 82
2369735 2369735 2022-04-03 Berrien Georgia 13019 4932 82
2366482 2366482 2022-04-02 Berrien Georgia 13019 4932 82
2363229 2363229 2022-04-01 Berrien Georgia 13019 4932 82
2359975 2359975 2022-03-31 Berrien Georgia 13019 4932 82
2356721 2356721 2022-03-30 Berrien Georgia 13019 4931 82
2353468 2353468 2022-03-29 Berrien Georgia 13019 4930 82
2350216 2350216 2022-03-28 Berrien Georgia 13019 4930 82
2346963 2346963 2022-03-27 Berrien Georgia 13019 4923 82
2343710 2343710 2022-03-26 Berrien Georgia 13019 4923 82
2340457 2340457 2022-03-25 Berrien Georgia 13019 4923 82
2337204 2337204 2022-03-24 Berrien Georgia 13019 4922 81
2333950 2333950 2022-03-23 Berrien Georgia 13019 4920 81
2330696 2330696 2022-03-22 Berrien Georgia 13019 4920 81
2327444 2327444 2022-03-21 Berrien Georgia 13019 4918 81
2324191 2324191 2022-03-20 Berrien Georgia 13019 4916 81
2320937 2320937 2022-03-19 Berrien Georgia 13019 4916 81
2317683 2317683 2022-03-18 Berrien Georgia 13019 4916 81
2314430 2314430 2022-03-17 Berrien Georgia 13019 4916 81
2311177 2311177 2022-03-16 Berrien Georgia 13019 4914 81
2307924 2307924 2022-03-15 Berrien Georgia 13019 4914 80
2304673 2304673 2022-03-14 Berrien Georgia 13019 4913 80
2301421 2301421 2022-03-13 Berrien Georgia 13019 4913 80
2298169 2298169 2022-03-12 Berrien Georgia 13019 4913 80
2294917 2294917 2022-03-11 Berrien Georgia 13019 4913 80
2291665 2291665 2022-03-10 Berrien Georgia 13019 4912 80
2288413 2288413 2022-03-09 Berrien Georgia 13019 4910 79
2285162 2285162 2022-03-08 Berrien Georgia 13019 4908 79
2281910 2281910 2022-03-07 Berrien Georgia 13019 4908 79
2278657 2278657 2022-03-06 Berrien Georgia 13019 4908 78
2275404 2275404 2022-03-05 Berrien Georgia 13019 4908 78
2272151 2272151 2022-03-04 Berrien Georgia 13019 4908 78
2268899 2268899 2022-03-03 Berrien Georgia 13019 4908 78
2265646 2265646 2022-03-02 Berrien Georgia 13019 4908 78
2262395 2262395 2022-03-01 Berrien Georgia 13019 4907 78
2259144 2259144 2022-02-28 Berrien Georgia 13019 4907 78
2255893 2255893 2022-02-27 Berrien Georgia 13019 4904 76
2252642 2252642 2022-02-26 Berrien Georgia 13019 4904 76
2249391 2249391 2022-02-25 Berrien Georgia 13019 4904 76
2246140 2246140 2022-02-24 Berrien Georgia 13019 4903 76
2242889 2242889 2022-02-23 Berrien Georgia 13019 4901 76
2239638 2239638 2022-02-22 Berrien Georgia 13019 4900 75
2236387 2236387 2022-02-21 Berrien Georgia 13019 4899 75
2233136 2233136 2022-02-20 Berrien Georgia 13019 4895 74
2229885 2229885 2022-02-19 Berrien Georgia 13019 4895 74
2226634 2226634 2022-02-18 Berrien Georgia 13019 4895 74
2223383 2223383 2022-02-17 Berrien Georgia 13019 4891 74
2220132 2220132 2022-02-16 Berrien Georgia 13019 4889 74
2216881 2216881 2022-02-15 Berrien Georgia 13019 4888 74
2213630 2213630 2022-02-14 Berrien Georgia 13019 4887 74
2210378 2210378 2022-02-13 Berrien Georgia 13019 4881 74
2207125 2207125 2022-02-12 Berrien Georgia 13019 4881 74
2203872 2203872 2022-02-11 Berrien Georgia 13019 4881 74
2200619 2200619 2022-02-10 Berrien Georgia 13019 4875 73
2197365 2197365 2022-02-09 Berrien Georgia 13019 4861 73
2194111 2194111 2022-02-08 Berrien Georgia 13019 4849 73
2190857 2190857 2022-02-07 Berrien Georgia 13019 4838 72
2187604 2187604 2022-02-06 Berrien Georgia 13019 4818 72
2184351 2184351 2022-02-05 Berrien Georgia 13019 4818 72
2181099 2181099 2022-02-04 Berrien Georgia 13019 4818 72
2177848 2177848 2022-02-03 Berrien Georgia 13019 4804 72

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);