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

785 rows where county = "Adams" and state = "Mississippi" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Mississippi · 785 ✖

fips 1

county 1

  • Adams · 785 ✖
Link rowid date ▲ county state fips cases deaths
2500993 2500993 2022-05-13 Adams Mississippi 28001 7224 143
2497735 2497735 2022-05-12 Adams Mississippi 28001 7224 143
2494477 2494477 2022-05-11 Adams Mississippi 28001 7224 143
2491219 2491219 2022-05-10 Adams Mississippi 28001 7224 143
2487962 2487962 2022-05-09 Adams Mississippi 28001 7224 143
2484704 2484704 2022-05-08 Adams Mississippi 28001 7174 142
2481446 2481446 2022-05-07 Adams Mississippi 28001 7174 142
2478188 2478188 2022-05-06 Adams Mississippi 28001 7174 142
2474930 2474930 2022-05-05 Adams Mississippi 28001 7174 142
2471673 2471673 2022-05-04 Adams Mississippi 28001 7174 142
2468417 2468417 2022-05-03 Adams Mississippi 28001 7174 142
2465162 2465162 2022-05-02 Adams Mississippi 28001 7174 142
2461906 2461906 2022-05-01 Adams Mississippi 28001 7158 142
2458650 2458650 2022-04-30 Adams Mississippi 28001 7158 142
2455394 2455394 2022-04-29 Adams Mississippi 28001 7158 142
2452138 2452138 2022-04-28 Adams Mississippi 28001 7158 142
2448882 2448882 2022-04-27 Adams Mississippi 28001 7158 142
2445626 2445626 2022-04-26 Adams Mississippi 28001 7158 142
2442370 2442370 2022-04-25 Adams Mississippi 28001 7152 142
2439114 2439114 2022-04-24 Adams Mississippi 28001 7152 142
2435858 2435858 2022-04-23 Adams Mississippi 28001 7152 142
2432602 2432602 2022-04-22 Adams Mississippi 28001 7152 142
2429346 2429346 2022-04-21 Adams Mississippi 28001 7152 142
2426090 2426090 2022-04-20 Adams Mississippi 28001 7152 142
2422834 2422834 2022-04-19 Adams Mississippi 28001 7152 142
2419578 2419578 2022-04-18 Adams Mississippi 28001 7152 142
2416322 2416322 2022-04-17 Adams Mississippi 28001 7150 142
2413066 2413066 2022-04-16 Adams Mississippi 28001 7150 142
2409810 2409810 2022-04-15 Adams Mississippi 28001 7150 142
2406554 2406554 2022-04-14 Adams Mississippi 28001 7150 142
2403298 2403298 2022-04-13 Adams Mississippi 28001 7150 142
2400044 2400044 2022-04-12 Adams Mississippi 28001 7150 142
2396788 2396788 2022-04-11 Adams Mississippi 28001 7136 142
2393533 2393533 2022-04-10 Adams Mississippi 28001 7136 142
2390277 2390277 2022-04-09 Adams Mississippi 28001 7136 142
2387021 2387021 2022-04-08 Adams Mississippi 28001 7136 142
2383766 2383766 2022-04-07 Adams Mississippi 28001 7136 142
2380511 2380511 2022-04-06 Adams Mississippi 28001 7136 142
2377256 2377256 2022-04-05 Adams Mississippi 28001 7136 142
2374004 2374004 2022-04-04 Adams Mississippi 28001 7136 142
2370751 2370751 2022-04-03 Adams Mississippi 28001 7126 142
2367498 2367498 2022-04-02 Adams Mississippi 28001 7126 142
2364245 2364245 2022-04-01 Adams Mississippi 28001 7126 142
2360991 2360991 2022-03-31 Adams Mississippi 28001 7126 142
2357737 2357737 2022-03-30 Adams Mississippi 28001 7126 142
2354484 2354484 2022-03-29 Adams Mississippi 28001 7126 142
2351232 2351232 2022-03-28 Adams Mississippi 28001 7126 142
2347979 2347979 2022-03-27 Adams Mississippi 28001 7122 142
2344726 2344726 2022-03-26 Adams Mississippi 28001 7122 142
2341473 2341473 2022-03-25 Adams Mississippi 28001 7122 142
2338220 2338220 2022-03-24 Adams Mississippi 28001 7122 142
2334966 2334966 2022-03-23 Adams Mississippi 28001 7122 142
2331712 2331712 2022-03-22 Adams Mississippi 28001 7122 142
2328460 2328460 2022-03-21 Adams Mississippi 28001 7122 142
2325207 2325207 2022-03-20 Adams Mississippi 28001 7120 142
2321953 2321953 2022-03-19 Adams Mississippi 28001 7120 142
2318699 2318699 2022-03-18 Adams Mississippi 28001 7120 142
2315446 2315446 2022-03-17 Adams Mississippi 28001 7120 142
2312193 2312193 2022-03-16 Adams Mississippi 28001 7120 142
2308940 2308940 2022-03-15 Adams Mississippi 28001 7120 142
2305689 2305689 2022-03-14 Adams Mississippi 28001 7120 142
2302437 2302437 2022-03-13 Adams Mississippi 28001 7119 141
2299185 2299185 2022-03-12 Adams Mississippi 28001 7119 141
2295933 2295933 2022-03-11 Adams Mississippi 28001 7119 141
2292681 2292681 2022-03-10 Adams Mississippi 28001 7119 141
2289429 2289429 2022-03-09 Adams Mississippi 28001 7119 141
2286178 2286178 2022-03-08 Adams Mississippi 28001 7119 141
2282926 2282926 2022-03-07 Adams Mississippi 28001 7106 141
2279673 2279673 2022-03-06 Adams Mississippi 28001 7104 141
2276420 2276420 2022-03-05 Adams Mississippi 28001 7104 141
2273167 2273167 2022-03-04 Adams Mississippi 28001 7104 141
2269915 2269915 2022-03-03 Adams Mississippi 28001 7104 141
2266662 2266662 2022-03-02 Adams Mississippi 28001 7104 141
2263411 2263411 2022-03-01 Adams Mississippi 28001 7104 141
2260160 2260160 2022-02-28 Adams Mississippi 28001 7104 140
2256909 2256909 2022-02-27 Adams Mississippi 28001 7102 140
2253658 2253658 2022-02-26 Adams Mississippi 28001 7102 140
2250407 2250407 2022-02-25 Adams Mississippi 28001 7102 140
2247156 2247156 2022-02-24 Adams Mississippi 28001 7102 140
2243905 2243905 2022-02-23 Adams Mississippi 28001 7102 140
2240654 2240654 2022-02-22 Adams Mississippi 28001 7099 140
2237403 2237403 2022-02-21 Adams Mississippi 28001 7070 140
2234152 2234152 2022-02-20 Adams Mississippi 28001 7070 140
2230901 2230901 2022-02-19 Adams Mississippi 28001 7070 140
2227650 2227650 2022-02-18 Adams Mississippi 28001 7070 140
2224399 2224399 2022-02-17 Adams Mississippi 28001 7063 140
2221148 2221148 2022-02-16 Adams Mississippi 28001 7055 140
2217897 2217897 2022-02-15 Adams Mississippi 28001 7047 139
2214646 2214646 2022-02-14 Adams Mississippi 28001 7038 139
2211394 2211394 2022-02-13 Adams Mississippi 28001 7015 139
2208141 2208141 2022-02-12 Adams Mississippi 28001 7015 139
2204888 2204888 2022-02-11 Adams Mississippi 28001 7015 139
2201635 2201635 2022-02-10 Adams Mississippi 28001 7004 139
2198381 2198381 2022-02-09 Adams Mississippi 28001 7003 137
2195127 2195127 2022-02-08 Adams Mississippi 28001 6963 137
2191873 2191873 2022-02-07 Adams Mississippi 28001 6946 133
2188620 2188620 2022-02-06 Adams Mississippi 28001 6637 133
2185367 2185367 2022-02-05 Adams Mississippi 28001 6637 133
2182115 2182115 2022-02-04 Adams Mississippi 28001 6637 133
2178863 2178863 2022-02-03 Adams Mississippi 28001 6554 133

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