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,526 rows where county = "Big Horn" 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

  • Big Horn · 1,526 ✖
Link rowid date ▲ county state fips cases deaths
2501194 2501194 2022-05-13 Big Horn Montana 30003 4980 96
2502811 2502811 2022-05-13 Big Horn Wyoming 56003 2586 61
2497936 2497936 2022-05-12 Big Horn Montana 30003 4976 95
2499553 2499553 2022-05-12 Big Horn Wyoming 56003 2586 61
2494678 2494678 2022-05-11 Big Horn Montana 30003 4976 95
2496295 2496295 2022-05-11 Big Horn Wyoming 56003 2586 61
2491420 2491420 2022-05-10 Big Horn Montana 30003 4976 95
2493037 2493037 2022-05-10 Big Horn Wyoming 56003 2586 61
2488162 2488162 2022-05-09 Big Horn Montana 30003 4976 95
2489779 2489779 2022-05-09 Big Horn Wyoming 56003 2583 61
2484905 2484905 2022-05-08 Big Horn Montana 30003 4976 95
2486522 2486522 2022-05-08 Big Horn Wyoming 56003 2583 61
2481647 2481647 2022-05-07 Big Horn Montana 30003 4976 95
2483264 2483264 2022-05-07 Big Horn Wyoming 56003 2583 61
2478389 2478389 2022-05-06 Big Horn Montana 30003 4976 95
2480006 2480006 2022-05-06 Big Horn Wyoming 56003 2583 61
2475131 2475131 2022-05-05 Big Horn Montana 30003 4975 95
2476748 2476748 2022-05-05 Big Horn Wyoming 56003 2583 61
2471874 2471874 2022-05-04 Big Horn Montana 30003 4975 95
2473490 2473490 2022-05-04 Big Horn Wyoming 56003 2583 61
2468618 2468618 2022-05-03 Big Horn Montana 30003 4971 95
2470233 2470233 2022-05-03 Big Horn Wyoming 56003 2583 61
2465362 2465362 2022-05-02 Big Horn Montana 30003 4969 95
2466977 2466977 2022-05-02 Big Horn Wyoming 56003 2583 61
2462107 2462107 2022-05-01 Big Horn Montana 30003 4969 95
2463722 2463722 2022-05-01 Big Horn Wyoming 56003 2583 61
2458851 2458851 2022-04-30 Big Horn Montana 30003 4969 95
2460466 2460466 2022-04-30 Big Horn Wyoming 56003 2583 61
2455595 2455595 2022-04-29 Big Horn Montana 30003 4969 95
2457210 2457210 2022-04-29 Big Horn Wyoming 56003 2583 61
2452339 2452339 2022-04-28 Big Horn Montana 30003 4968 94
2453954 2453954 2022-04-28 Big Horn Wyoming 56003 2583 61
2449083 2449083 2022-04-27 Big Horn Montana 30003 4967 94
2450698 2450698 2022-04-27 Big Horn Wyoming 56003 2583 61
2445826 2445826 2022-04-26 Big Horn Montana 30003 4967 94
2447442 2447442 2022-04-26 Big Horn Wyoming 56003 2583 61
2442571 2442571 2022-04-25 Big Horn Montana 30003 4966 94
2444186 2444186 2022-04-25 Big Horn Wyoming 56003 2580 60
2439315 2439315 2022-04-24 Big Horn Montana 30003 4964 94
2440930 2440930 2022-04-24 Big Horn Wyoming 56003 2580 60
2436059 2436059 2022-04-23 Big Horn Montana 30003 4964 94
2437674 2437674 2022-04-23 Big Horn Wyoming 56003 2580 60
2432803 2432803 2022-04-22 Big Horn Montana 30003 4964 94
2434418 2434418 2022-04-22 Big Horn Wyoming 56003 2580 60
2429547 2429547 2022-04-21 Big Horn Montana 30003 4963 94
2431162 2431162 2022-04-21 Big Horn Wyoming 56003 2580 60
2426291 2426291 2022-04-20 Big Horn Montana 30003 4961 94
2427906 2427906 2022-04-20 Big Horn Wyoming 56003 2580 60
2423035 2423035 2022-04-19 Big Horn Montana 30003 4961 94
2424650 2424650 2022-04-19 Big Horn Wyoming 56003 2580 60
2419778 2419778 2022-04-18 Big Horn Montana 30003 4961 94
2421394 2421394 2022-04-18 Big Horn Wyoming 56003 2579 60
2416523 2416523 2022-04-17 Big Horn Montana 30003 4960 94
2418138 2418138 2022-04-17 Big Horn Wyoming 56003 2579 60
2413267 2413267 2022-04-16 Big Horn Montana 30003 4960 94
2414882 2414882 2022-04-16 Big Horn Wyoming 56003 2579 60
2410011 2410011 2022-04-15 Big Horn Montana 30003 4960 94
2411626 2411626 2022-04-15 Big Horn Wyoming 56003 2579 60
2406755 2406755 2022-04-14 Big Horn Montana 30003 4959 94
2408370 2408370 2022-04-14 Big Horn Wyoming 56003 2579 60
2403499 2403499 2022-04-13 Big Horn Montana 30003 4958 94
2405114 2405114 2022-04-13 Big Horn Wyoming 56003 2579 60
2400244 2400244 2022-04-12 Big Horn Montana 30003 4957 94
2401859 2401859 2022-04-12 Big Horn Wyoming 56003 2579 60
2396989 2396989 2022-04-11 Big Horn Montana 30003 4956 92
2398604 2398604 2022-04-11 Big Horn Wyoming 56003 2579 60
2393734 2393734 2022-04-10 Big Horn Montana 30003 4956 92
2395349 2395349 2022-04-10 Big Horn Wyoming 56003 2579 60
2390478 2390478 2022-04-09 Big Horn Montana 30003 4956 92
2392093 2392093 2022-04-09 Big Horn Wyoming 56003 2579 60
2387222 2387222 2022-04-08 Big Horn Montana 30003 4956 92
2388837 2388837 2022-04-08 Big Horn Wyoming 56003 2579 60
2383967 2383967 2022-04-07 Big Horn Montana 30003 4956 92
2385582 2385582 2022-04-07 Big Horn Wyoming 56003 2579 60
2380712 2380712 2022-04-06 Big Horn Montana 30003 4956 92
2382327 2382327 2022-04-06 Big Horn Wyoming 56003 2579 60
2377457 2377457 2022-04-05 Big Horn Montana 30003 4956 92
2379072 2379072 2022-04-05 Big Horn Wyoming 56003 2579 60
2374204 2374204 2022-04-04 Big Horn Montana 30003 4956 92
2375818 2375818 2022-04-04 Big Horn Wyoming 56003 2578 60
2370952 2370952 2022-04-03 Big Horn Montana 30003 4956 92
2372566 2372566 2022-04-03 Big Horn Wyoming 56003 2578 60
2367699 2367699 2022-04-02 Big Horn Montana 30003 4956 92
2369313 2369313 2022-04-02 Big Horn Wyoming 56003 2578 60
2364446 2364446 2022-04-01 Big Horn Montana 30003 4956 92
2366060 2366060 2022-04-01 Big Horn Wyoming 56003 2578 60
2361192 2361192 2022-03-31 Big Horn Montana 30003 4956 92
2362807 2362807 2022-03-31 Big Horn Wyoming 56003 2577 60
2357938 2357938 2022-03-30 Big Horn Montana 30003 4956 92
2359553 2359553 2022-03-30 Big Horn Wyoming 56003 2577 60
2354685 2354685 2022-03-29 Big Horn Montana 30003 4955 92
2356299 2356299 2022-03-29 Big Horn Wyoming 56003 2577 60
2351432 2351432 2022-03-28 Big Horn Montana 30003 4954 92
2353046 2353046 2022-03-28 Big Horn Wyoming 56003 2575 60
2348180 2348180 2022-03-27 Big Horn Montana 30003 4953 92
2349794 2349794 2022-03-27 Big Horn Wyoming 56003 2575 60
2344927 2344927 2022-03-26 Big Horn Montana 30003 4953 92
2346541 2346541 2022-03-26 Big Horn Wyoming 56003 2575 60
2341674 2341674 2022-03-25 Big Horn Montana 30003 4953 92
2343288 2343288 2022-03-25 Big Horn Wyoming 56003 2575 60

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