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

784 rows where fips = 28151 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 · 784 ✖

fips 1

  • 28151 · 784 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501069 2501069 2022-05-13 Washington Mississippi 28151 10470 199
2497811 2497811 2022-05-12 Washington Mississippi 28151 10470 199
2494553 2494553 2022-05-11 Washington Mississippi 28151 10470 199
2491295 2491295 2022-05-10 Washington Mississippi 28151 10470 199
2488037 2488037 2022-05-09 Washington Mississippi 28151 10470 199
2484780 2484780 2022-05-08 Washington Mississippi 28151 10423 199
2481522 2481522 2022-05-07 Washington Mississippi 28151 10423 199
2478264 2478264 2022-05-06 Washington Mississippi 28151 10423 199
2475006 2475006 2022-05-05 Washington Mississippi 28151 10423 199
2471749 2471749 2022-05-04 Washington Mississippi 28151 10423 199
2468493 2468493 2022-05-03 Washington Mississippi 28151 10423 199
2465237 2465237 2022-05-02 Washington Mississippi 28151 10423 199
2461982 2461982 2022-05-01 Washington Mississippi 28151 10417 198
2458726 2458726 2022-04-30 Washington Mississippi 28151 10417 198
2455470 2455470 2022-04-29 Washington Mississippi 28151 10417 198
2452214 2452214 2022-04-28 Washington Mississippi 28151 10417 198
2448958 2448958 2022-04-27 Washington Mississippi 28151 10417 198
2445701 2445701 2022-04-26 Washington Mississippi 28151 10417 198
2442446 2442446 2022-04-25 Washington Mississippi 28151 10416 198
2439190 2439190 2022-04-24 Washington Mississippi 28151 10416 198
2435934 2435934 2022-04-23 Washington Mississippi 28151 10416 198
2432678 2432678 2022-04-22 Washington Mississippi 28151 10416 198
2429422 2429422 2022-04-21 Washington Mississippi 28151 10416 198
2426166 2426166 2022-04-20 Washington Mississippi 28151 10416 198
2422910 2422910 2022-04-19 Washington Mississippi 28151 10416 198
2419653 2419653 2022-04-18 Washington Mississippi 28151 10416 198
2416398 2416398 2022-04-17 Washington Mississippi 28151 10413 198
2413142 2413142 2022-04-16 Washington Mississippi 28151 10413 198
2409886 2409886 2022-04-15 Washington Mississippi 28151 10413 198
2406630 2406630 2022-04-14 Washington Mississippi 28151 10413 198
2403374 2403374 2022-04-13 Washington Mississippi 28151 10413 198
2400119 2400119 2022-04-12 Washington Mississippi 28151 10413 198
2396864 2396864 2022-04-11 Washington Mississippi 28151 10376 197
2393609 2393609 2022-04-10 Washington Mississippi 28151 10376 197
2390353 2390353 2022-04-09 Washington Mississippi 28151 10376 197
2387097 2387097 2022-04-08 Washington Mississippi 28151 10376 197
2383842 2383842 2022-04-07 Washington Mississippi 28151 10376 197
2380587 2380587 2022-04-06 Washington Mississippi 28151 10376 197
2377332 2377332 2022-04-05 Washington Mississippi 28151 10376 197
2374079 2374079 2022-04-04 Washington Mississippi 28151 10376 197
2370827 2370827 2022-04-03 Washington Mississippi 28151 10353 197
2367574 2367574 2022-04-02 Washington Mississippi 28151 10353 197
2364321 2364321 2022-04-01 Washington Mississippi 28151 10353 197
2361067 2361067 2022-03-31 Washington Mississippi 28151 10353 197
2357813 2357813 2022-03-30 Washington Mississippi 28151 10353 197
2354560 2354560 2022-03-29 Washington Mississippi 28151 10353 197
2351307 2351307 2022-03-28 Washington Mississippi 28151 10353 197
2348055 2348055 2022-03-27 Washington Mississippi 28151 10344 196
2344802 2344802 2022-03-26 Washington Mississippi 28151 10344 196
2341549 2341549 2022-03-25 Washington Mississippi 28151 10344 196
2338296 2338296 2022-03-24 Washington Mississippi 28151 10344 196
2335042 2335042 2022-03-23 Washington Mississippi 28151 10344 196
2331788 2331788 2022-03-22 Washington Mississippi 28151 10344 196
2328535 2328535 2022-03-21 Washington Mississippi 28151 10344 196
2325283 2325283 2022-03-20 Washington Mississippi 28151 10327 195
2322029 2322029 2022-03-19 Washington Mississippi 28151 10327 195
2318775 2318775 2022-03-18 Washington Mississippi 28151 10327 195
2315522 2315522 2022-03-17 Washington Mississippi 28151 10327 195
2312269 2312269 2022-03-16 Washington Mississippi 28151 10327 195
2309016 2309016 2022-03-15 Washington Mississippi 28151 10327 195
2305764 2305764 2022-03-14 Washington Mississippi 28151 10327 195
2302513 2302513 2022-03-13 Washington Mississippi 28151 10248 195
2299261 2299261 2022-03-12 Washington Mississippi 28151 10248 195
2296009 2296009 2022-03-11 Washington Mississippi 28151 10248 195
2292757 2292757 2022-03-10 Washington Mississippi 28151 10248 195
2289505 2289505 2022-03-09 Washington Mississippi 28151 10248 195
2286253 2286253 2022-03-08 Washington Mississippi 28151 10248 195
2283001 2283001 2022-03-07 Washington Mississippi 28151 10248 195
2279748 2279748 2022-03-06 Washington Mississippi 28151 10226 195
2276495 2276495 2022-03-05 Washington Mississippi 28151 10226 195
2273242 2273242 2022-03-04 Washington Mississippi 28151 10226 195
2269990 2269990 2022-03-03 Washington Mississippi 28151 10224 195
2266737 2266737 2022-03-02 Washington Mississippi 28151 10224 195
2263486 2263486 2022-03-01 Washington Mississippi 28151 10217 194
2260235 2260235 2022-02-28 Washington Mississippi 28151 10196 194
2256984 2256984 2022-02-27 Washington Mississippi 28151 10156 194
2253733 2253733 2022-02-26 Washington Mississippi 28151 10156 194
2250482 2250482 2022-02-25 Washington Mississippi 28151 10156 194
2247231 2247231 2022-02-24 Washington Mississippi 28151 10136 194
2243980 2243980 2022-02-23 Washington Mississippi 28151 10120 193
2240729 2240729 2022-02-22 Washington Mississippi 28151 10094 189
2237478 2237478 2022-02-21 Washington Mississippi 28151 10083 188
2234227 2234227 2022-02-20 Washington Mississippi 28151 10083 188
2230976 2230976 2022-02-19 Washington Mississippi 28151 10083 188
2227725 2227725 2022-02-18 Washington Mississippi 28151 10083 188
2224474 2224474 2022-02-17 Washington Mississippi 28151 10076 188
2221223 2221223 2022-02-16 Washington Mississippi 28151 10074 188
2217972 2217972 2022-02-15 Washington Mississippi 28151 10061 187
2214721 2214721 2022-02-14 Washington Mississippi 28151 10048 187
2211469 2211469 2022-02-13 Washington Mississippi 28151 9991 185
2208216 2208216 2022-02-12 Washington Mississippi 28151 9991 185
2204963 2204963 2022-02-11 Washington Mississippi 28151 9991 185
2201710 2201710 2022-02-10 Washington Mississippi 28151 9963 184
2198456 2198456 2022-02-09 Washington Mississippi 28151 9904 184
2195202 2195202 2022-02-08 Washington Mississippi 28151 9849 181
2191948 2191948 2022-02-07 Washington Mississippi 28151 9844 181
2188695 2188695 2022-02-06 Washington Mississippi 28151 9682 179
2185442 2185442 2022-02-05 Washington Mississippi 28151 9682 179
2182190 2182190 2022-02-04 Washington Mississippi 28151 9682 179
2178938 2178938 2022-02-03 Washington Mississippi 28151 9620 179

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