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

1,518 rows where county = "Bell" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 2

fips 2

county 1

  • Bell · 1,518 ✖
Link rowid date ▲ county state fips cases deaths
2500585 2500585 2022-05-13 Bell Kentucky 21013 8868 149
2502220 2502220 2022-05-13 Bell Texas 48027 67290 901
2497327 2497327 2022-05-12 Bell Kentucky 21013 8868 149
2498962 2498962 2022-05-12 Bell Texas 48027 67271 900
2494069 2494069 2022-05-11 Bell Kentucky 21013 8868 149
2495704 2495704 2022-05-11 Bell Texas 48027 67243 900
2490811 2490811 2022-05-10 Bell Kentucky 21013 8868 149
2492446 2492446 2022-05-10 Bell Texas 48027 67225 900
2487554 2487554 2022-05-09 Bell Kentucky 21013 8868 149
2489188 2489188 2022-05-09 Bell Texas 48027 67211 900
2484296 2484296 2022-05-08 Bell Kentucky 21013 8866 149
2485931 2485931 2022-05-08 Bell Texas 48027 67201 900
2481038 2481038 2022-05-07 Bell Kentucky 21013 8866 149
2482673 2482673 2022-05-07 Bell Texas 48027 67188 900
2477780 2477780 2022-05-06 Bell Kentucky 21013 8866 149
2479415 2479415 2022-05-06 Bell Texas 48027 67169 900
2474522 2474522 2022-05-05 Bell Kentucky 21013 8866 149
2476157 2476157 2022-05-05 Bell Texas 48027 67147 899
2471265 2471265 2022-05-04 Bell Kentucky 21013 8866 149
2472900 2472900 2022-05-04 Bell Texas 48027 67128 901
2468009 2468009 2022-05-03 Bell Kentucky 21013 8866 149
2469644 2469644 2022-05-03 Bell Texas 48027 67116 901
2464754 2464754 2022-05-02 Bell Kentucky 21013 8866 149
2466388 2466388 2022-05-02 Bell Texas 48027 67107 901
2461498 2461498 2022-05-01 Bell Kentucky 21013 8861 147
2463133 2463133 2022-05-01 Bell Texas 48027 67097 901
2458242 2458242 2022-04-30 Bell Kentucky 21013 8861 147
2459877 2459877 2022-04-30 Bell Texas 48027 67090 901
2454986 2454986 2022-04-29 Bell Kentucky 21013 8861 147
2456621 2456621 2022-04-29 Bell Texas 48027 67072 901
2451730 2451730 2022-04-28 Bell Kentucky 21013 8861 147
2453365 2453365 2022-04-28 Bell Texas 48027 67056 901
2448474 2448474 2022-04-27 Bell Kentucky 21013 8861 147
2450109 2450109 2022-04-27 Bell Texas 48027 67042 900
2445218 2445218 2022-04-26 Bell Kentucky 21013 8861 147
2446852 2446852 2022-04-26 Bell Texas 48027 67037 898
2441962 2441962 2022-04-25 Bell Kentucky 21013 8861 147
2443597 2443597 2022-04-25 Bell Texas 48027 67029 897
2438706 2438706 2022-04-24 Bell Kentucky 21013 8855 147
2440341 2440341 2022-04-24 Bell Texas 48027 67020 897
2435450 2435450 2022-04-23 Bell Kentucky 21013 8855 147
2437085 2437085 2022-04-23 Bell Texas 48027 67009 897
2432194 2432194 2022-04-22 Bell Kentucky 21013 8855 147
2433829 2433829 2022-04-22 Bell Texas 48027 66996 897
2428938 2428938 2022-04-21 Bell Kentucky 21013 8855 147
2430573 2430573 2022-04-21 Bell Texas 48027 66976 897
2425682 2425682 2022-04-20 Bell Kentucky 21013 8855 147
2427317 2427317 2022-04-20 Bell Texas 48027 66969 896
2422426 2422426 2022-04-19 Bell Kentucky 21013 8855 147
2424061 2424061 2022-04-19 Bell Texas 48027 66961 896
2419170 2419170 2022-04-18 Bell Kentucky 21013 8855 147
2420805 2420805 2022-04-18 Bell Texas 48027 66957 896
2415914 2415914 2022-04-17 Bell Kentucky 21013 8854 146
2417549 2417549 2022-04-17 Bell Texas 48027 66927 896
2412658 2412658 2022-04-16 Bell Kentucky 21013 8854 146
2414293 2414293 2022-04-16 Bell Texas 48027 66927 896
2409402 2409402 2022-04-15 Bell Kentucky 21013 8854 146
2411037 2411037 2022-04-15 Bell Texas 48027 66927 896
2406146 2406146 2022-04-14 Bell Kentucky 21013 8854 146
2407781 2407781 2022-04-14 Bell Texas 48027 66927 896
2402890 2402890 2022-04-13 Bell Kentucky 21013 8854 146
2404525 2404525 2022-04-13 Bell Texas 48027 66920 896
2399636 2399636 2022-04-12 Bell Kentucky 21013 8854 146
2401270 2401270 2022-04-12 Bell Texas 48027 66913 895
2396380 2396380 2022-04-11 Bell Kentucky 21013 8854 146
2398015 2398015 2022-04-11 Bell Texas 48027 66909 894
2393125 2393125 2022-04-10 Bell Kentucky 21013 8850 143
2394760 2394760 2022-04-10 Bell Texas 48027 66904 894
2389869 2389869 2022-04-09 Bell Kentucky 21013 8850 143
2391504 2391504 2022-04-09 Bell Texas 48027 66896 894
2386613 2386613 2022-04-08 Bell Kentucky 21013 8850 143
2388248 2388248 2022-04-08 Bell Texas 48027 66885 894
2383358 2383358 2022-04-07 Bell Kentucky 21013 8850 143
2384993 2384993 2022-04-07 Bell Texas 48027 66880 894
2380103 2380103 2022-04-06 Bell Kentucky 21013 8850 143
2381738 2381738 2022-04-06 Bell Texas 48027 66869 893
2376848 2376848 2022-04-05 Bell Kentucky 21013 8850 143
2378483 2378483 2022-04-05 Bell Texas 48027 66859 892
2373596 2373596 2022-04-04 Bell Kentucky 21013 8850 143
2375229 2375229 2022-04-04 Bell Texas 48027 66852 892
2370343 2370343 2022-04-03 Bell Kentucky 21013 8847 142
2371977 2371977 2022-04-03 Bell Texas 48027 66845 892
2367090 2367090 2022-04-02 Bell Kentucky 21013 8847 142
2368724 2368724 2022-04-02 Bell Texas 48027 66832 890
2363837 2363837 2022-04-01 Bell Kentucky 21013 8847 142
2365471 2365471 2022-04-01 Bell Texas 48027 66817 889
2360583 2360583 2022-03-31 Bell Kentucky 21013 8847 142
2362218 2362218 2022-03-31 Bell Texas 48027 66806 888
2357329 2357329 2022-03-30 Bell Kentucky 21013 8847 142
2358964 2358964 2022-03-30 Bell Texas 48027 66796 887
2354076 2354076 2022-03-29 Bell Kentucky 21013 8847 142
2355710 2355710 2022-03-29 Bell Texas 48027 66785 886
2350824 2350824 2022-03-28 Bell Kentucky 21013 8847 142
2352457 2352457 2022-03-28 Bell Texas 48027 66776 885
2347571 2347571 2022-03-27 Bell Kentucky 21013 8836 141
2349205 2349205 2022-03-27 Bell Texas 48027 66773 885
2344318 2344318 2022-03-26 Bell Kentucky 21013 8836 141
2345952 2345952 2022-03-26 Bell Texas 48027 66768 884
2341065 2341065 2022-03-25 Bell Kentucky 21013 8836 141
2342699 2342699 2022-03-25 Bell Texas 48027 66759 883

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