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

2,302 rows where county = "Meade" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 3

fips 3

county 1

  • Meade · 2,302 ✖
Link rowid date ▲ county state fips cases deaths
2500532 2500532 2022-05-13 Meade Kansas 20119 1221 20
2500660 2500660 2022-05-13 Meade Kentucky 21163 5821 66
2502090 2502090 2022-05-13 Meade South Dakota 46093 7042 64
2497274 2497274 2022-05-12 Meade Kansas 20119 1220 20
2497402 2497402 2022-05-12 Meade Kentucky 21163 5821 66
2498832 2498832 2022-05-12 Meade South Dakota 46093 7042 64
2494016 2494016 2022-05-11 Meade Kansas 20119 1220 20
2494144 2494144 2022-05-11 Meade Kentucky 21163 5821 66
2495574 2495574 2022-05-11 Meade South Dakota 46093 7042 64
2490758 2490758 2022-05-10 Meade Kansas 20119 1220 20
2490886 2490886 2022-05-10 Meade Kentucky 21163 5821 66
2492316 2492316 2022-05-10 Meade South Dakota 46093 7027 64
2487501 2487501 2022-05-09 Meade Kansas 20119 1220 20
2487629 2487629 2022-05-09 Meade Kentucky 21163 5821 66
2489058 2489058 2022-05-09 Meade South Dakota 46093 7027 64
2484243 2484243 2022-05-08 Meade Kansas 20119 1220 20
2484371 2484371 2022-05-08 Meade Kentucky 21163 5813 66
2485801 2485801 2022-05-08 Meade South Dakota 46093 7027 64
2480985 2480985 2022-05-07 Meade Kansas 20119 1220 20
2481113 2481113 2022-05-07 Meade Kentucky 21163 5813 66
2482543 2482543 2022-05-07 Meade South Dakota 46093 7027 64
2477727 2477727 2022-05-06 Meade Kansas 20119 1220 20
2477855 2477855 2022-05-06 Meade Kentucky 21163 5813 66
2479285 2479285 2022-05-06 Meade South Dakota 46093 7027 64
2474469 2474469 2022-05-05 Meade Kansas 20119 1220 20
2474597 2474597 2022-05-05 Meade Kentucky 21163 5813 66
2476027 2476027 2022-05-05 Meade South Dakota 46093 7027 64
2471212 2471212 2022-05-04 Meade Kansas 20119 1220 20
2471340 2471340 2022-05-04 Meade Kentucky 21163 5813 66
2472770 2472770 2022-05-04 Meade South Dakota 46093 7027 64
2467956 2467956 2022-05-03 Meade Kansas 20119 1220 20
2468084 2468084 2022-05-03 Meade Kentucky 21163 5813 66
2469514 2469514 2022-05-03 Meade South Dakota 46093 7020 64
2464701 2464701 2022-05-02 Meade Kansas 20119 1220 20
2464829 2464829 2022-05-02 Meade Kentucky 21163 5813 66
2466258 2466258 2022-05-02 Meade South Dakota 46093 7020 64
2461445 2461445 2022-05-01 Meade Kansas 20119 1220 20
2461573 2461573 2022-05-01 Meade Kentucky 21163 5808 66
2463003 2463003 2022-05-01 Meade South Dakota 46093 7020 64
2458189 2458189 2022-04-30 Meade Kansas 20119 1220 20
2458317 2458317 2022-04-30 Meade Kentucky 21163 5808 66
2459747 2459747 2022-04-30 Meade South Dakota 46093 7020 64
2454933 2454933 2022-04-29 Meade Kansas 20119 1220 20
2455061 2455061 2022-04-29 Meade Kentucky 21163 5808 66
2456491 2456491 2022-04-29 Meade South Dakota 46093 7020 64
2451677 2451677 2022-04-28 Meade Kansas 20119 1220 20
2451805 2451805 2022-04-28 Meade Kentucky 21163 5808 66
2453235 2453235 2022-04-28 Meade South Dakota 46093 7020 64
2448421 2448421 2022-04-27 Meade Kansas 20119 1220 20
2448549 2448549 2022-04-27 Meade Kentucky 21163 5808 66
2449979 2449979 2022-04-27 Meade South Dakota 46093 7020 64
2445165 2445165 2022-04-26 Meade Kansas 20119 1220 20
2445293 2445293 2022-04-26 Meade Kentucky 21163 5808 66
2446722 2446722 2022-04-26 Meade South Dakota 46093 7010 64
2441909 2441909 2022-04-25 Meade Kansas 20119 1220 20
2442037 2442037 2022-04-25 Meade Kentucky 21163 5808 66
2443467 2443467 2022-04-25 Meade South Dakota 46093 7010 64
2438653 2438653 2022-04-24 Meade Kansas 20119 1220 20
2438781 2438781 2022-04-24 Meade Kentucky 21163 5800 65
2440211 2440211 2022-04-24 Meade South Dakota 46093 7010 64
2435397 2435397 2022-04-23 Meade Kansas 20119 1220 20
2435525 2435525 2022-04-23 Meade Kentucky 21163 5800 65
2436955 2436955 2022-04-23 Meade South Dakota 46093 7010 64
2432141 2432141 2022-04-22 Meade Kansas 20119 1220 20
2432269 2432269 2022-04-22 Meade Kentucky 21163 5800 65
2433699 2433699 2022-04-22 Meade South Dakota 46093 7010 64
2428885 2428885 2022-04-21 Meade Kansas 20119 1220 20
2429013 2429013 2022-04-21 Meade Kentucky 21163 5800 65
2430443 2430443 2022-04-21 Meade South Dakota 46093 7010 64
2425629 2425629 2022-04-20 Meade Kansas 20119 1220 20
2425757 2425757 2022-04-20 Meade Kentucky 21163 5800 65
2427187 2427187 2022-04-20 Meade South Dakota 46093 7010 64
2422373 2422373 2022-04-19 Meade Kansas 20119 1220 20
2422501 2422501 2022-04-19 Meade Kentucky 21163 5800 65
2423931 2423931 2022-04-19 Meade South Dakota 46093 7007 63
2419117 2419117 2022-04-18 Meade Kansas 20119 1220 20
2419245 2419245 2022-04-18 Meade Kentucky 21163 5800 65
2420675 2420675 2022-04-18 Meade South Dakota 46093 7007 63
2415861 2415861 2022-04-17 Meade Kansas 20119 1220 20
2415989 2415989 2022-04-17 Meade Kentucky 21163 5797 65
2417419 2417419 2022-04-17 Meade South Dakota 46093 7007 63
2412605 2412605 2022-04-16 Meade Kansas 20119 1220 20
2412733 2412733 2022-04-16 Meade Kentucky 21163 5797 65
2414163 2414163 2022-04-16 Meade South Dakota 46093 7007 63
2409349 2409349 2022-04-15 Meade Kansas 20119 1220 20
2409477 2409477 2022-04-15 Meade Kentucky 21163 5797 65
2410907 2410907 2022-04-15 Meade South Dakota 46093 7007 63
2406093 2406093 2022-04-14 Meade Kansas 20119 1221 20
2406221 2406221 2022-04-14 Meade Kentucky 21163 5797 65
2407651 2407651 2022-04-14 Meade South Dakota 46093 7007 63
2402837 2402837 2022-04-13 Meade Kansas 20119 1221 20
2402965 2402965 2022-04-13 Meade Kentucky 21163 5797 65
2404395 2404395 2022-04-13 Meade South Dakota 46093 7007 63
2399583 2399583 2022-04-12 Meade Kansas 20119 1221 20
2399711 2399711 2022-04-12 Meade Kentucky 21163 5797 65
2401140 2401140 2022-04-12 Meade South Dakota 46093 7004 62
2396327 2396327 2022-04-11 Meade Kansas 20119 1221 20
2396455 2396455 2022-04-11 Meade Kentucky 21163 5797 65
2397885 2397885 2022-04-11 Meade South Dakota 46093 7004 62
2393072 2393072 2022-04-10 Meade Kansas 20119 1221 20

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