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

786 rows where fips = 28067 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 · 786 ✖

fips 1

  • 28067 · 786 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501026 2501026 2022-05-13 Jones Mississippi 28067 21234 295
2497768 2497768 2022-05-12 Jones Mississippi 28067 21234 295
2494510 2494510 2022-05-11 Jones Mississippi 28067 21234 295
2491252 2491252 2022-05-10 Jones Mississippi 28067 21234 295
2487995 2487995 2022-05-09 Jones Mississippi 28067 21234 295
2484737 2484737 2022-05-08 Jones Mississippi 28067 21214 295
2481479 2481479 2022-05-07 Jones Mississippi 28067 21214 295
2478221 2478221 2022-05-06 Jones Mississippi 28067 21214 295
2474963 2474963 2022-05-05 Jones Mississippi 28067 21214 295
2471706 2471706 2022-05-04 Jones Mississippi 28067 21214 295
2468450 2468450 2022-05-03 Jones Mississippi 28067 21214 295
2465195 2465195 2022-05-02 Jones Mississippi 28067 21214 295
2461939 2461939 2022-05-01 Jones Mississippi 28067 21206 293
2458683 2458683 2022-04-30 Jones Mississippi 28067 21206 293
2455427 2455427 2022-04-29 Jones Mississippi 28067 21206 293
2452171 2452171 2022-04-28 Jones Mississippi 28067 21206 293
2448915 2448915 2022-04-27 Jones Mississippi 28067 21206 293
2445659 2445659 2022-04-26 Jones Mississippi 28067 21206 293
2442403 2442403 2022-04-25 Jones Mississippi 28067 21190 291
2439147 2439147 2022-04-24 Jones Mississippi 28067 21190 291
2435891 2435891 2022-04-23 Jones Mississippi 28067 21190 291
2432635 2432635 2022-04-22 Jones Mississippi 28067 21190 291
2429379 2429379 2022-04-21 Jones Mississippi 28067 21190 291
2426123 2426123 2022-04-20 Jones Mississippi 28067 21190 291
2422867 2422867 2022-04-19 Jones Mississippi 28067 21190 291
2419611 2419611 2022-04-18 Jones Mississippi 28067 21190 291
2416355 2416355 2022-04-17 Jones Mississippi 28067 21178 291
2413099 2413099 2022-04-16 Jones Mississippi 28067 21178 291
2409843 2409843 2022-04-15 Jones Mississippi 28067 21178 291
2406587 2406587 2022-04-14 Jones Mississippi 28067 21178 291
2403331 2403331 2022-04-13 Jones Mississippi 28067 21178 291
2400077 2400077 2022-04-12 Jones Mississippi 28067 21178 291
2396821 2396821 2022-04-11 Jones Mississippi 28067 21167 290
2393566 2393566 2022-04-10 Jones Mississippi 28067 21167 290
2390310 2390310 2022-04-09 Jones Mississippi 28067 21167 290
2387054 2387054 2022-04-08 Jones Mississippi 28067 21167 290
2383799 2383799 2022-04-07 Jones Mississippi 28067 21167 290
2380544 2380544 2022-04-06 Jones Mississippi 28067 21167 290
2377289 2377289 2022-04-05 Jones Mississippi 28067 21167 290
2374037 2374037 2022-04-04 Jones Mississippi 28067 21167 290
2370784 2370784 2022-04-03 Jones Mississippi 28067 21154 289
2367531 2367531 2022-04-02 Jones Mississippi 28067 21154 289
2364278 2364278 2022-04-01 Jones Mississippi 28067 21154 289
2361024 2361024 2022-03-31 Jones Mississippi 28067 21154 289
2357770 2357770 2022-03-30 Jones Mississippi 28067 21154 289
2354517 2354517 2022-03-29 Jones Mississippi 28067 21154 289
2351265 2351265 2022-03-28 Jones Mississippi 28067 21154 289
2348012 2348012 2022-03-27 Jones Mississippi 28067 21146 289
2344759 2344759 2022-03-26 Jones Mississippi 28067 21146 289
2341506 2341506 2022-03-25 Jones Mississippi 28067 21146 289
2338253 2338253 2022-03-24 Jones Mississippi 28067 21146 289
2334999 2334999 2022-03-23 Jones Mississippi 28067 21146 289
2331745 2331745 2022-03-22 Jones Mississippi 28067 21146 289
2328493 2328493 2022-03-21 Jones Mississippi 28067 21146 289
2325240 2325240 2022-03-20 Jones Mississippi 28067 21124 289
2321986 2321986 2022-03-19 Jones Mississippi 28067 21124 289
2318732 2318732 2022-03-18 Jones Mississippi 28067 21124 289
2315479 2315479 2022-03-17 Jones Mississippi 28067 21124 289
2312226 2312226 2022-03-16 Jones Mississippi 28067 21124 289
2308973 2308973 2022-03-15 Jones Mississippi 28067 21124 289
2305722 2305722 2022-03-14 Jones Mississippi 28067 21124 289
2302470 2302470 2022-03-13 Jones Mississippi 28067 21107 287
2299218 2299218 2022-03-12 Jones Mississippi 28067 21107 287
2295966 2295966 2022-03-11 Jones Mississippi 28067 21107 287
2292714 2292714 2022-03-10 Jones Mississippi 28067 21107 287
2289462 2289462 2022-03-09 Jones Mississippi 28067 21107 287
2286211 2286211 2022-03-08 Jones Mississippi 28067 21107 287
2282959 2282959 2022-03-07 Jones Mississippi 28067 21106 287
2279706 2279706 2022-03-06 Jones Mississippi 28067 21101 287
2276453 2276453 2022-03-05 Jones Mississippi 28067 21101 287
2273200 2273200 2022-03-04 Jones Mississippi 28067 21101 287
2269948 2269948 2022-03-03 Jones Mississippi 28067 21097 287
2266695 2266695 2022-03-02 Jones Mississippi 28067 21095 287
2263444 2263444 2022-03-01 Jones Mississippi 28067 21094 287
2260193 2260193 2022-02-28 Jones Mississippi 28067 21094 286
2256942 2256942 2022-02-27 Jones Mississippi 28067 21082 285
2253691 2253691 2022-02-26 Jones Mississippi 28067 21082 285
2250440 2250440 2022-02-25 Jones Mississippi 28067 21082 285
2247189 2247189 2022-02-24 Jones Mississippi 28067 21072 284
2243938 2243938 2022-02-23 Jones Mississippi 28067 21063 284
2240687 2240687 2022-02-22 Jones Mississippi 28067 21051 282
2237436 2237436 2022-02-21 Jones Mississippi 28067 20993 282
2234185 2234185 2022-02-20 Jones Mississippi 28067 20993 282
2230934 2230934 2022-02-19 Jones Mississippi 28067 20993 282
2227683 2227683 2022-02-18 Jones Mississippi 28067 20993 282
2224432 2224432 2022-02-17 Jones Mississippi 28067 20970 280
2221181 2221181 2022-02-16 Jones Mississippi 28067 20942 280
2217930 2217930 2022-02-15 Jones Mississippi 28067 20917 277
2214679 2214679 2022-02-14 Jones Mississippi 28067 20913 277
2211427 2211427 2022-02-13 Jones Mississippi 28067 20827 275
2208174 2208174 2022-02-12 Jones Mississippi 28067 20827 275
2204921 2204921 2022-02-11 Jones Mississippi 28067 20827 275
2201668 2201668 2022-02-10 Jones Mississippi 28067 20747 274
2198414 2198414 2022-02-09 Jones Mississippi 28067 20688 272
2195160 2195160 2022-02-08 Jones Mississippi 28067 20631 270
2191906 2191906 2022-02-07 Jones Mississippi 28067 20604 267
2188653 2188653 2022-02-06 Jones Mississippi 28067 20278 266
2185400 2185400 2022-02-05 Jones Mississippi 28067 20278 266
2182148 2182148 2022-02-04 Jones Mississippi 28067 20278 266
2178896 2178896 2022-02-03 Jones Mississippi 28067 20101 265

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