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,546 rows where county = "Craig" 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

  • Craig · 1,546 ✖
Link rowid date ▲ county state fips cases deaths
2501750 2501750 2022-05-13 Craig Oklahoma 40035 4785 55
2502539 2502539 2022-05-13 Craig Virginia 51045 1128 18
2498492 2498492 2022-05-12 Craig Oklahoma 40035 4785 55
2499281 2499281 2022-05-12 Craig Virginia 51045 1128 18
2495234 2495234 2022-05-11 Craig Oklahoma 40035 4782 55
2496023 2496023 2022-05-11 Craig Virginia 51045 1128 18
2491976 2491976 2022-05-10 Craig Oklahoma 40035 4782 55
2492765 2492765 2022-05-10 Craig Virginia 51045 1127 18
2488718 2488718 2022-05-09 Craig Oklahoma 40035 4782 55
2489507 2489507 2022-05-09 Craig Virginia 51045 1127 18
2485461 2485461 2022-05-08 Craig Oklahoma 40035 4782 55
2486250 2486250 2022-05-08 Craig Virginia 51045 1127 18
2482203 2482203 2022-05-07 Craig Oklahoma 40035 4782 55
2482992 2482992 2022-05-07 Craig Virginia 51045 1127 18
2478945 2478945 2022-05-06 Craig Oklahoma 40035 4782 55
2479734 2479734 2022-05-06 Craig Virginia 51045 1127 18
2475687 2475687 2022-05-05 Craig Oklahoma 40035 4782 55
2476476 2476476 2022-05-05 Craig Virginia 51045 1127 18
2472430 2472430 2022-05-04 Craig Oklahoma 40035 4773 55
2473218 2473218 2022-05-04 Craig Virginia 51045 1126 18
2469174 2469174 2022-05-03 Craig Oklahoma 40035 4773 55
2469962 2469962 2022-05-03 Craig Virginia 51045 1125 18
2465918 2465918 2022-05-02 Craig Oklahoma 40035 4773 55
2466706 2466706 2022-05-02 Craig Virginia 51045 1124 18
2462663 2462663 2022-05-01 Craig Oklahoma 40035 4773 55
2463451 2463451 2022-05-01 Craig Virginia 51045 1123 18
2459407 2459407 2022-04-30 Craig Oklahoma 40035 4773 55
2460195 2460195 2022-04-30 Craig Virginia 51045 1123 18
2456151 2456151 2022-04-29 Craig Oklahoma 40035 4773 55
2456939 2456939 2022-04-29 Craig Virginia 51045 1123 18
2452895 2452895 2022-04-28 Craig Oklahoma 40035 4773 55
2453683 2453683 2022-04-28 Craig Virginia 51045 1123 18
2449639 2449639 2022-04-27 Craig Oklahoma 40035 4770 55
2450427 2450427 2022-04-27 Craig Virginia 51045 1123 18
2446382 2446382 2022-04-26 Craig Oklahoma 40035 4770 55
2447170 2447170 2022-04-26 Craig Virginia 51045 1123 18
2443127 2443127 2022-04-25 Craig Oklahoma 40035 4770 55
2443915 2443915 2022-04-25 Craig Virginia 51045 1121 18
2439871 2439871 2022-04-24 Craig Oklahoma 40035 4770 55
2440659 2440659 2022-04-24 Craig Virginia 51045 1120 18
2436615 2436615 2022-04-23 Craig Oklahoma 40035 4770 55
2437403 2437403 2022-04-23 Craig Virginia 51045 1120 18
2433359 2433359 2022-04-22 Craig Oklahoma 40035 4770 55
2434147 2434147 2022-04-22 Craig Virginia 51045 1120 18
2430103 2430103 2022-04-21 Craig Oklahoma 40035 4770 55
2430891 2430891 2022-04-21 Craig Virginia 51045 1120 18
2426847 2426847 2022-04-20 Craig Oklahoma 40035 4763 54
2427635 2427635 2022-04-20 Craig Virginia 51045 1119 18
2423591 2423591 2022-04-19 Craig Oklahoma 40035 4763 54
2424379 2424379 2022-04-19 Craig Virginia 51045 1119 18
2420334 2420334 2022-04-18 Craig Oklahoma 40035 4763 54
2421123 2421123 2022-04-18 Craig Virginia 51045 1119 18
2417079 2417079 2022-04-17 Craig Oklahoma 40035 4763 54
2417867 2417867 2022-04-17 Craig Virginia 51045 1119 18
2413823 2413823 2022-04-16 Craig Oklahoma 40035 4763 54
2414611 2414611 2022-04-16 Craig Virginia 51045 1119 18
2410567 2410567 2022-04-15 Craig Oklahoma 40035 4763 54
2411355 2411355 2022-04-15 Craig Virginia 51045 1119 18
2407311 2407311 2022-04-14 Craig Oklahoma 40035 4763 54
2408099 2408099 2022-04-14 Craig Virginia 51045 1119 18
2404055 2404055 2022-04-13 Craig Oklahoma 40035 4759 53
2404843 2404843 2022-04-13 Craig Virginia 51045 1119 18
2400800 2400800 2022-04-12 Craig Oklahoma 40035 4759 53
2401588 2401588 2022-04-12 Craig Virginia 51045 1119 18
2397545 2397545 2022-04-11 Craig Oklahoma 40035 4759 53
2398333 2398333 2022-04-11 Craig Virginia 51045 1117 18
2394290 2394290 2022-04-10 Craig Oklahoma 40035 4759 53
2395078 2395078 2022-04-10 Craig Virginia 51045 1117 18
2391034 2391034 2022-04-09 Craig Oklahoma 40035 4759 53
2391822 2391822 2022-04-09 Craig Virginia 51045 1117 18
2387778 2387778 2022-04-08 Craig Oklahoma 40035 4759 53
2388566 2388566 2022-04-08 Craig Virginia 51045 1117 18
2384523 2384523 2022-04-07 Craig Oklahoma 40035 4759 53
2385311 2385311 2022-04-07 Craig Virginia 51045 1117 18
2381268 2381268 2022-04-06 Craig Oklahoma 40035 4760 52
2382056 2382056 2022-04-06 Craig Virginia 51045 1117 18
2378013 2378013 2022-04-05 Craig Oklahoma 40035 4760 52
2378801 2378801 2022-04-05 Craig Virginia 51045 1117 18
2374759 2374759 2022-04-04 Craig Oklahoma 40035 4760 52
2375547 2375547 2022-04-04 Craig Virginia 51045 1117 18
2371507 2371507 2022-04-03 Craig Oklahoma 40035 4760 52
2372295 2372295 2022-04-03 Craig Virginia 51045 1117 18
2368254 2368254 2022-04-02 Craig Oklahoma 40035 4760 52
2369042 2369042 2022-04-02 Craig Virginia 51045 1117 18
2365001 2365001 2022-04-01 Craig Oklahoma 40035 4760 52
2365789 2365789 2022-04-01 Craig Virginia 51045 1117 18
2361748 2361748 2022-03-31 Craig Oklahoma 40035 4760 52
2362536 2362536 2022-03-31 Craig Virginia 51045 1115 18
2358494 2358494 2022-03-30 Craig Oklahoma 40035 4737 52
2359282 2359282 2022-03-30 Craig Virginia 51045 1113 18
2355240 2355240 2022-03-29 Craig Oklahoma 40035 4737 52
2356028 2356028 2022-03-29 Craig Virginia 51045 1113 17
2351987 2351987 2022-03-28 Craig Oklahoma 40035 4737 52
2352775 2352775 2022-03-28 Craig Virginia 51045 1113 17
2348735 2348735 2022-03-27 Craig Oklahoma 40035 4737 52
2349523 2349523 2022-03-27 Craig Virginia 51045 1113 17
2345482 2345482 2022-03-26 Craig Oklahoma 40035 4737 52
2346270 2346270 2022-03-26 Craig Virginia 51045 1113 17
2342229 2342229 2022-03-25 Craig Oklahoma 40035 4737 52
2343017 2343017 2022-03-25 Craig Virginia 51045 1113 17

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