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

726 rows where county = "Bell" and state = "Kentucky" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Kentucky · 726 ✖

fips 1

county 1

  • Bell · 726 ✖
Link rowid date ▲ county state fips cases deaths
2500585 2500585 2022-05-13 Bell Kentucky 21013 8868 149
2497327 2497327 2022-05-12 Bell Kentucky 21013 8868 149
2494069 2494069 2022-05-11 Bell Kentucky 21013 8868 149
2490811 2490811 2022-05-10 Bell Kentucky 21013 8868 149
2487554 2487554 2022-05-09 Bell Kentucky 21013 8868 149
2484296 2484296 2022-05-08 Bell Kentucky 21013 8866 149
2481038 2481038 2022-05-07 Bell Kentucky 21013 8866 149
2477780 2477780 2022-05-06 Bell Kentucky 21013 8866 149
2474522 2474522 2022-05-05 Bell Kentucky 21013 8866 149
2471265 2471265 2022-05-04 Bell Kentucky 21013 8866 149
2468009 2468009 2022-05-03 Bell Kentucky 21013 8866 149
2464754 2464754 2022-05-02 Bell Kentucky 21013 8866 149
2461498 2461498 2022-05-01 Bell Kentucky 21013 8861 147
2458242 2458242 2022-04-30 Bell Kentucky 21013 8861 147
2454986 2454986 2022-04-29 Bell Kentucky 21013 8861 147
2451730 2451730 2022-04-28 Bell Kentucky 21013 8861 147
2448474 2448474 2022-04-27 Bell Kentucky 21013 8861 147
2445218 2445218 2022-04-26 Bell Kentucky 21013 8861 147
2441962 2441962 2022-04-25 Bell Kentucky 21013 8861 147
2438706 2438706 2022-04-24 Bell Kentucky 21013 8855 147
2435450 2435450 2022-04-23 Bell Kentucky 21013 8855 147
2432194 2432194 2022-04-22 Bell Kentucky 21013 8855 147
2428938 2428938 2022-04-21 Bell Kentucky 21013 8855 147
2425682 2425682 2022-04-20 Bell Kentucky 21013 8855 147
2422426 2422426 2022-04-19 Bell Kentucky 21013 8855 147
2419170 2419170 2022-04-18 Bell Kentucky 21013 8855 147
2415914 2415914 2022-04-17 Bell Kentucky 21013 8854 146
2412658 2412658 2022-04-16 Bell Kentucky 21013 8854 146
2409402 2409402 2022-04-15 Bell Kentucky 21013 8854 146
2406146 2406146 2022-04-14 Bell Kentucky 21013 8854 146
2402890 2402890 2022-04-13 Bell Kentucky 21013 8854 146
2399636 2399636 2022-04-12 Bell Kentucky 21013 8854 146
2396380 2396380 2022-04-11 Bell Kentucky 21013 8854 146
2393125 2393125 2022-04-10 Bell Kentucky 21013 8850 143
2389869 2389869 2022-04-09 Bell Kentucky 21013 8850 143
2386613 2386613 2022-04-08 Bell Kentucky 21013 8850 143
2383358 2383358 2022-04-07 Bell Kentucky 21013 8850 143
2380103 2380103 2022-04-06 Bell Kentucky 21013 8850 143
2376848 2376848 2022-04-05 Bell Kentucky 21013 8850 143
2373596 2373596 2022-04-04 Bell Kentucky 21013 8850 143
2370343 2370343 2022-04-03 Bell Kentucky 21013 8847 142
2367090 2367090 2022-04-02 Bell Kentucky 21013 8847 142
2363837 2363837 2022-04-01 Bell Kentucky 21013 8847 142
2360583 2360583 2022-03-31 Bell Kentucky 21013 8847 142
2357329 2357329 2022-03-30 Bell Kentucky 21013 8847 142
2354076 2354076 2022-03-29 Bell Kentucky 21013 8847 142
2350824 2350824 2022-03-28 Bell Kentucky 21013 8847 142
2347571 2347571 2022-03-27 Bell Kentucky 21013 8836 141
2344318 2344318 2022-03-26 Bell Kentucky 21013 8836 141
2341065 2341065 2022-03-25 Bell Kentucky 21013 8836 141
2337812 2337812 2022-03-24 Bell Kentucky 21013 8836 141
2334558 2334558 2022-03-23 Bell Kentucky 21013 8836 141
2331304 2331304 2022-03-22 Bell Kentucky 21013 8836 141
2328052 2328052 2022-03-21 Bell Kentucky 21013 8836 141
2324799 2324799 2022-03-20 Bell Kentucky 21013 8821 136
2321545 2321545 2022-03-19 Bell Kentucky 21013 8821 136
2318291 2318291 2022-03-18 Bell Kentucky 21013 8821 136
2315038 2315038 2022-03-17 Bell Kentucky 21013 8821 136
2311785 2311785 2022-03-16 Bell Kentucky 21013 8821 136
2308532 2308532 2022-03-15 Bell Kentucky 21013 8821 136
2305281 2305281 2022-03-14 Bell Kentucky 21013 8821 136
2302029 2302029 2022-03-13 Bell Kentucky 21013 8780 132
2298777 2298777 2022-03-12 Bell Kentucky 21013 8780 132
2295525 2295525 2022-03-11 Bell Kentucky 21013 8780 132
2292273 2292273 2022-03-10 Bell Kentucky 21013 8780 132
2289021 2289021 2022-03-09 Bell Kentucky 21013 8780 132
2285770 2285770 2022-03-08 Bell Kentucky 21013 8780 132
2282518 2282518 2022-03-07 Bell Kentucky 21013 8780 132
2279265 2279265 2022-03-06 Bell Kentucky 21013 8774 132
2276012 2276012 2022-03-05 Bell Kentucky 21013 8774 132
2272759 2272759 2022-03-04 Bell Kentucky 21013 8774 132
2269507 2269507 2022-03-03 Bell Kentucky 21013 8771 131
2266254 2266254 2022-03-02 Bell Kentucky 21013 8767 130
2263003 2263003 2022-03-01 Bell Kentucky 21013 8762 130
2259752 2259752 2022-02-28 Bell Kentucky 21013 8754 129
2256501 2256501 2022-02-27 Bell Kentucky 21013 8739 129
2253250 2253250 2022-02-26 Bell Kentucky 21013 8739 129
2249999 2249999 2022-02-25 Bell Kentucky 21013 8739 129
2246748 2246748 2022-02-24 Bell Kentucky 21013 8712 128
2243497 2243497 2022-02-23 Bell Kentucky 21013 8712 128
2240246 2240246 2022-02-22 Bell Kentucky 21013 8694 128
2236995 2236995 2022-02-21 Bell Kentucky 21013 8685 128
2233744 2233744 2022-02-20 Bell Kentucky 21013 8642 128
2230493 2230493 2022-02-19 Bell Kentucky 21013 8642 128
2227242 2227242 2022-02-18 Bell Kentucky 21013 8642 128
2223991 2223991 2022-02-17 Bell Kentucky 21013 8609 127
2220740 2220740 2022-02-16 Bell Kentucky 21013 8569 127
2217489 2217489 2022-02-15 Bell Kentucky 21013 8535 126
2214238 2214238 2022-02-14 Bell Kentucky 21013 8512 126
2210986 2210986 2022-02-13 Bell Kentucky 21013 8319 124
2207733 2207733 2022-02-12 Bell Kentucky 21013 8319 124
2204480 2204480 2022-02-11 Bell Kentucky 21013 8319 124
2201227 2201227 2022-02-10 Bell Kentucky 21013 8241 124
2197973 2197973 2022-02-09 Bell Kentucky 21013 8207 123
2194719 2194719 2022-02-08 Bell Kentucky 21013 8166 123
2191465 2191465 2022-02-07 Bell Kentucky 21013 8131 123
2188212 2188212 2022-02-06 Bell Kentucky 21013 8063 123
2184959 2184959 2022-02-05 Bell Kentucky 21013 8063 123
2181707 2181707 2022-02-04 Bell Kentucky 21013 8063 123
2178456 2178456 2022-02-03 Bell Kentucky 21013 8027 123

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