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

778 rows where county = "Jefferson" and fips = 28063 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 28063 · 778 ✖

county 1

  • Jefferson · 778 ✖
Link rowid date ▲ county state fips cases deaths
2501024 2501024 2022-05-13 Jefferson Mississippi 28063 1494 37
2497766 2497766 2022-05-12 Jefferson Mississippi 28063 1494 37
2494508 2494508 2022-05-11 Jefferson Mississippi 28063 1494 37
2491250 2491250 2022-05-10 Jefferson Mississippi 28063 1494 37
2487993 2487993 2022-05-09 Jefferson Mississippi 28063 1494 37
2484735 2484735 2022-05-08 Jefferson Mississippi 28063 1490 37
2481477 2481477 2022-05-07 Jefferson Mississippi 28063 1490 37
2478219 2478219 2022-05-06 Jefferson Mississippi 28063 1490 37
2474961 2474961 2022-05-05 Jefferson Mississippi 28063 1490 37
2471704 2471704 2022-05-04 Jefferson Mississippi 28063 1490 37
2468448 2468448 2022-05-03 Jefferson Mississippi 28063 1490 37
2465193 2465193 2022-05-02 Jefferson Mississippi 28063 1490 37
2461937 2461937 2022-05-01 Jefferson Mississippi 28063 1484 37
2458681 2458681 2022-04-30 Jefferson Mississippi 28063 1484 37
2455425 2455425 2022-04-29 Jefferson Mississippi 28063 1484 37
2452169 2452169 2022-04-28 Jefferson Mississippi 28063 1484 37
2448913 2448913 2022-04-27 Jefferson Mississippi 28063 1484 37
2445657 2445657 2022-04-26 Jefferson Mississippi 28063 1484 37
2442401 2442401 2022-04-25 Jefferson Mississippi 28063 1482 37
2439145 2439145 2022-04-24 Jefferson Mississippi 28063 1482 37
2435889 2435889 2022-04-23 Jefferson Mississippi 28063 1482 37
2432633 2432633 2022-04-22 Jefferson Mississippi 28063 1482 37
2429377 2429377 2022-04-21 Jefferson Mississippi 28063 1482 37
2426121 2426121 2022-04-20 Jefferson Mississippi 28063 1482 37
2422865 2422865 2022-04-19 Jefferson Mississippi 28063 1482 37
2419609 2419609 2022-04-18 Jefferson Mississippi 28063 1482 37
2416353 2416353 2022-04-17 Jefferson Mississippi 28063 1479 37
2413097 2413097 2022-04-16 Jefferson Mississippi 28063 1479 37
2409841 2409841 2022-04-15 Jefferson Mississippi 28063 1479 37
2406585 2406585 2022-04-14 Jefferson Mississippi 28063 1479 37
2403329 2403329 2022-04-13 Jefferson Mississippi 28063 1479 37
2400075 2400075 2022-04-12 Jefferson Mississippi 28063 1479 37
2396819 2396819 2022-04-11 Jefferson Mississippi 28063 1471 37
2393564 2393564 2022-04-10 Jefferson Mississippi 28063 1471 37
2390308 2390308 2022-04-09 Jefferson Mississippi 28063 1471 37
2387052 2387052 2022-04-08 Jefferson Mississippi 28063 1471 37
2383797 2383797 2022-04-07 Jefferson Mississippi 28063 1471 37
2380542 2380542 2022-04-06 Jefferson Mississippi 28063 1471 37
2377287 2377287 2022-04-05 Jefferson Mississippi 28063 1471 37
2374035 2374035 2022-04-04 Jefferson Mississippi 28063 1471 37
2370782 2370782 2022-04-03 Jefferson Mississippi 28063 1470 37
2367529 2367529 2022-04-02 Jefferson Mississippi 28063 1470 37
2364276 2364276 2022-04-01 Jefferson Mississippi 28063 1470 37
2361022 2361022 2022-03-31 Jefferson Mississippi 28063 1470 37
2357768 2357768 2022-03-30 Jefferson Mississippi 28063 1470 37
2354515 2354515 2022-03-29 Jefferson Mississippi 28063 1470 37
2351263 2351263 2022-03-28 Jefferson Mississippi 28063 1470 37
2348010 2348010 2022-03-27 Jefferson Mississippi 28063 1469 37
2344757 2344757 2022-03-26 Jefferson Mississippi 28063 1469 37
2341504 2341504 2022-03-25 Jefferson Mississippi 28063 1469 37
2338251 2338251 2022-03-24 Jefferson Mississippi 28063 1469 37
2334997 2334997 2022-03-23 Jefferson Mississippi 28063 1469 37
2331743 2331743 2022-03-22 Jefferson Mississippi 28063 1469 37
2328491 2328491 2022-03-21 Jefferson Mississippi 28063 1469 37
2325238 2325238 2022-03-20 Jefferson Mississippi 28063 1469 37
2321984 2321984 2022-03-19 Jefferson Mississippi 28063 1469 37
2318730 2318730 2022-03-18 Jefferson Mississippi 28063 1469 37
2315477 2315477 2022-03-17 Jefferson Mississippi 28063 1469 37
2312224 2312224 2022-03-16 Jefferson Mississippi 28063 1469 37
2308971 2308971 2022-03-15 Jefferson Mississippi 28063 1469 37
2305720 2305720 2022-03-14 Jefferson Mississippi 28063 1469 37
2302468 2302468 2022-03-13 Jefferson Mississippi 28063 1469 37
2299216 2299216 2022-03-12 Jefferson Mississippi 28063 1469 37
2295964 2295964 2022-03-11 Jefferson Mississippi 28063 1469 37
2292712 2292712 2022-03-10 Jefferson Mississippi 28063 1469 37
2289460 2289460 2022-03-09 Jefferson Mississippi 28063 1469 37
2286209 2286209 2022-03-08 Jefferson Mississippi 28063 1469 37
2282957 2282957 2022-03-07 Jefferson Mississippi 28063 1470 37
2279704 2279704 2022-03-06 Jefferson Mississippi 28063 1470 37
2276451 2276451 2022-03-05 Jefferson Mississippi 28063 1470 37
2273198 2273198 2022-03-04 Jefferson Mississippi 28063 1470 37
2269946 2269946 2022-03-03 Jefferson Mississippi 28063 1470 37
2266693 2266693 2022-03-02 Jefferson Mississippi 28063 1470 37
2263442 2263442 2022-03-01 Jefferson Mississippi 28063 1470 37
2260191 2260191 2022-02-28 Jefferson Mississippi 28063 1470 37
2256940 2256940 2022-02-27 Jefferson Mississippi 28063 1470 37
2253689 2253689 2022-02-26 Jefferson Mississippi 28063 1470 37
2250438 2250438 2022-02-25 Jefferson Mississippi 28063 1470 37
2247187 2247187 2022-02-24 Jefferson Mississippi 28063 1470 37
2243936 2243936 2022-02-23 Jefferson Mississippi 28063 1469 37
2240685 2240685 2022-02-22 Jefferson Mississippi 28063 1469 37
2237434 2237434 2022-02-21 Jefferson Mississippi 28063 1467 37
2234183 2234183 2022-02-20 Jefferson Mississippi 28063 1467 37
2230932 2230932 2022-02-19 Jefferson Mississippi 28063 1467 37
2227681 2227681 2022-02-18 Jefferson Mississippi 28063 1467 37
2224430 2224430 2022-02-17 Jefferson Mississippi 28063 1467 37
2221179 2221179 2022-02-16 Jefferson Mississippi 28063 1467 37
2217928 2217928 2022-02-15 Jefferson Mississippi 28063 1467 37
2214677 2214677 2022-02-14 Jefferson Mississippi 28063 1465 36
2211425 2211425 2022-02-13 Jefferson Mississippi 28063 1463 36
2208172 2208172 2022-02-12 Jefferson Mississippi 28063 1463 36
2204919 2204919 2022-02-11 Jefferson Mississippi 28063 1463 36
2201666 2201666 2022-02-10 Jefferson Mississippi 28063 1463 36
2198412 2198412 2022-02-09 Jefferson Mississippi 28063 1463 36
2195158 2195158 2022-02-08 Jefferson Mississippi 28063 1458 35
2191904 2191904 2022-02-07 Jefferson Mississippi 28063 1455 35
2188651 2188651 2022-02-06 Jefferson Mississippi 28063 1409 35
2185398 2185398 2022-02-05 Jefferson Mississippi 28063 1409 35
2182146 2182146 2022-02-04 Jefferson Mississippi 28063 1409 35
2178894 2178894 2022-02-03 Jefferson Mississippi 28063 1406 35

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