ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,944 rows where county = "Mineral" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 4
- Colorado 776
- West Virginia 771
- Nevada 756
- Montana 641
county 1
- Mineral · 2,944 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499860 | 2499860 | 2022-05-13 | Mineral | Colorado | 8079 | 241 | 2 |
2501223 | 2501223 | 2022-05-13 | Mineral | Montana | 30061 | 1100 | 17 |
2501354 | 2501354 | 2022-05-13 | Mineral | Nevada | 32021 | 1267 | 17 |
2502711 | 2502711 | 2022-05-13 | Mineral | West Virginia | 54057 | 7914 | 156 |
2496602 | 2496602 | 2022-05-12 | Mineral | Colorado | 8079 | 238 | 2 |
2497965 | 2497965 | 2022-05-12 | Mineral | Montana | 30061 | 1100 | 17 |
2498096 | 2498096 | 2022-05-12 | Mineral | Nevada | 32021 | 1267 | 17 |
2499453 | 2499453 | 2022-05-12 | Mineral | West Virginia | 54057 | 7912 | 156 |
2493344 | 2493344 | 2022-05-11 | Mineral | Colorado | 8079 | 237 | 2 |
2494707 | 2494707 | 2022-05-11 | Mineral | Montana | 30061 | 1100 | 17 |
2494838 | 2494838 | 2022-05-11 | Mineral | Nevada | 32021 | 1267 | 17 |
2496195 | 2496195 | 2022-05-11 | Mineral | West Virginia | 54057 | 7907 | 156 |
2490086 | 2490086 | 2022-05-10 | Mineral | Colorado | 8079 | 237 | 2 |
2491449 | 2491449 | 2022-05-10 | Mineral | Montana | 30061 | 1100 | 17 |
2491580 | 2491580 | 2022-05-10 | Mineral | Nevada | 32021 | 1266 | 17 |
2492937 | 2492937 | 2022-05-10 | Mineral | West Virginia | 54057 | 7902 | 156 |
2486829 | 2486829 | 2022-05-09 | Mineral | Colorado | 8079 | 233 | 2 |
2488191 | 2488191 | 2022-05-09 | Mineral | Montana | 30061 | 1100 | 17 |
2488322 | 2488322 | 2022-05-09 | Mineral | Nevada | 32021 | 1266 | 17 |
2489679 | 2489679 | 2022-05-09 | Mineral | West Virginia | 54057 | 7902 | 156 |
2483571 | 2483571 | 2022-05-08 | Mineral | Colorado | 8079 | 233 | 2 |
2484934 | 2484934 | 2022-05-08 | Mineral | Montana | 30061 | 1100 | 17 |
2485065 | 2485065 | 2022-05-08 | Mineral | Nevada | 32021 | 1266 | 17 |
2486422 | 2486422 | 2022-05-08 | Mineral | West Virginia | 54057 | 7893 | 156 |
2480313 | 2480313 | 2022-05-07 | Mineral | Colorado | 8079 | 233 | 2 |
2481676 | 2481676 | 2022-05-07 | Mineral | Montana | 30061 | 1100 | 17 |
2481807 | 2481807 | 2022-05-07 | Mineral | Nevada | 32021 | 1266 | 17 |
2483164 | 2483164 | 2022-05-07 | Mineral | West Virginia | 54057 | 7893 | 156 |
2477055 | 2477055 | 2022-05-06 | Mineral | Colorado | 8079 | 233 | 2 |
2478418 | 2478418 | 2022-05-06 | Mineral | Montana | 30061 | 1100 | 17 |
2478549 | 2478549 | 2022-05-06 | Mineral | Nevada | 32021 | 1266 | 17 |
2479906 | 2479906 | 2022-05-06 | Mineral | West Virginia | 54057 | 7893 | 156 |
2473797 | 2473797 | 2022-05-05 | Mineral | Colorado | 8079 | 233 | 2 |
2475160 | 2475160 | 2022-05-05 | Mineral | Montana | 30061 | 1100 | 17 |
2475291 | 2475291 | 2022-05-05 | Mineral | Nevada | 32021 | 1266 | 17 |
2476648 | 2476648 | 2022-05-05 | Mineral | West Virginia | 54057 | 7892 | 156 |
2470540 | 2470540 | 2022-05-04 | Mineral | Colorado | 8079 | 233 | 2 |
2471903 | 2471903 | 2022-05-04 | Mineral | Montana | 30061 | 1100 | 17 |
2472034 | 2472034 | 2022-05-04 | Mineral | Nevada | 32021 | 1266 | 17 |
2473390 | 2473390 | 2022-05-04 | Mineral | West Virginia | 54057 | 7890 | 156 |
2467284 | 2467284 | 2022-05-03 | Mineral | Colorado | 8079 | 233 | 2 |
2468647 | 2468647 | 2022-05-03 | Mineral | Montana | 30061 | 1100 | 17 |
2468778 | 2468778 | 2022-05-03 | Mineral | Nevada | 32021 | 1262 | 17 |
2470133 | 2470133 | 2022-05-03 | Mineral | West Virginia | 54057 | 7889 | 156 |
2464029 | 2464029 | 2022-05-02 | Mineral | Colorado | 8079 | 233 | 2 |
2465391 | 2465391 | 2022-05-02 | Mineral | Montana | 30061 | 1098 | 17 |
2465522 | 2465522 | 2022-05-02 | Mineral | Nevada | 32021 | 1262 | 17 |
2466877 | 2466877 | 2022-05-02 | Mineral | West Virginia | 54057 | 7889 | 156 |
2460773 | 2460773 | 2022-05-01 | Mineral | Colorado | 8079 | 233 | 2 |
2462136 | 2462136 | 2022-05-01 | Mineral | Montana | 30061 | 1098 | 17 |
2462267 | 2462267 | 2022-05-01 | Mineral | Nevada | 32021 | 1262 | 17 |
2463622 | 2463622 | 2022-05-01 | Mineral | West Virginia | 54057 | 7886 | 156 |
2457517 | 2457517 | 2022-04-30 | Mineral | Colorado | 8079 | 233 | 2 |
2458880 | 2458880 | 2022-04-30 | Mineral | Montana | 30061 | 1098 | 17 |
2459011 | 2459011 | 2022-04-30 | Mineral | Nevada | 32021 | 1262 | 17 |
2460366 | 2460366 | 2022-04-30 | Mineral | West Virginia | 54057 | 7886 | 156 |
2454261 | 2454261 | 2022-04-29 | Mineral | Colorado | 8079 | 233 | 2 |
2455624 | 2455624 | 2022-04-29 | Mineral | Montana | 30061 | 1098 | 17 |
2455755 | 2455755 | 2022-04-29 | Mineral | Nevada | 32021 | 1262 | 17 |
2457110 | 2457110 | 2022-04-29 | Mineral | West Virginia | 54057 | 7886 | 156 |
2451005 | 2451005 | 2022-04-28 | Mineral | Colorado | 8079 | 233 | 2 |
2452368 | 2452368 | 2022-04-28 | Mineral | Montana | 30061 | 1097 | 17 |
2452499 | 2452499 | 2022-04-28 | Mineral | Nevada | 32021 | 1262 | 17 |
2453854 | 2453854 | 2022-04-28 | Mineral | West Virginia | 54057 | 7886 | 156 |
2447749 | 2447749 | 2022-04-27 | Mineral | Colorado | 8079 | 233 | 2 |
2449112 | 2449112 | 2022-04-27 | Mineral | Montana | 30061 | 1096 | 17 |
2449243 | 2449243 | 2022-04-27 | Mineral | Nevada | 32021 | 1262 | 17 |
2450598 | 2450598 | 2022-04-27 | Mineral | West Virginia | 54057 | 7883 | 156 |
2444493 | 2444493 | 2022-04-26 | Mineral | Colorado | 8079 | 233 | 2 |
2445855 | 2445855 | 2022-04-26 | Mineral | Montana | 30061 | 1096 | 17 |
2445986 | 2445986 | 2022-04-26 | Mineral | Nevada | 32021 | 1262 | 17 |
2447342 | 2447342 | 2022-04-26 | Mineral | West Virginia | 54057 | 7882 | 156 |
2441237 | 2441237 | 2022-04-25 | Mineral | Colorado | 8079 | 233 | 2 |
2442600 | 2442600 | 2022-04-25 | Mineral | Montana | 30061 | 1096 | 17 |
2442731 | 2442731 | 2022-04-25 | Mineral | Nevada | 32021 | 1262 | 17 |
2444086 | 2444086 | 2022-04-25 | Mineral | West Virginia | 54057 | 7880 | 156 |
2437981 | 2437981 | 2022-04-24 | Mineral | Colorado | 8079 | 233 | 2 |
2439344 | 2439344 | 2022-04-24 | Mineral | Montana | 30061 | 1095 | 17 |
2439475 | 2439475 | 2022-04-24 | Mineral | Nevada | 32021 | 1262 | 17 |
2440830 | 2440830 | 2022-04-24 | Mineral | West Virginia | 54057 | 7875 | 156 |
2434725 | 2434725 | 2022-04-23 | Mineral | Colorado | 8079 | 233 | 2 |
2436088 | 2436088 | 2022-04-23 | Mineral | Montana | 30061 | 1095 | 17 |
2436219 | 2436219 | 2022-04-23 | Mineral | Nevada | 32021 | 1262 | 17 |
2437574 | 2437574 | 2022-04-23 | Mineral | West Virginia | 54057 | 7875 | 156 |
2431469 | 2431469 | 2022-04-22 | Mineral | Colorado | 8079 | 233 | 2 |
2432832 | 2432832 | 2022-04-22 | Mineral | Montana | 30061 | 1095 | 17 |
2432963 | 2432963 | 2022-04-22 | Mineral | Nevada | 32021 | 1262 | 17 |
2434318 | 2434318 | 2022-04-22 | Mineral | West Virginia | 54057 | 7875 | 156 |
2428213 | 2428213 | 2022-04-21 | Mineral | Colorado | 8079 | 233 | 2 |
2429576 | 2429576 | 2022-04-21 | Mineral | Montana | 30061 | 1095 | 17 |
2429707 | 2429707 | 2022-04-21 | Mineral | Nevada | 32021 | 1262 | 17 |
2431062 | 2431062 | 2022-04-21 | Mineral | West Virginia | 54057 | 7872 | 156 |
2424957 | 2424957 | 2022-04-20 | Mineral | Colorado | 8079 | 233 | 1 |
2426320 | 2426320 | 2022-04-20 | Mineral | Montana | 30061 | 1094 | 17 |
2426451 | 2426451 | 2022-04-20 | Mineral | Nevada | 32021 | 1262 | 17 |
2427806 | 2427806 | 2022-04-20 | Mineral | West Virginia | 54057 | 7868 | 156 |
2421701 | 2421701 | 2022-04-19 | Mineral | Colorado | 8079 | 230 | 1 |
2423064 | 2423064 | 2022-04-19 | Mineral | Montana | 30061 | 1092 | 17 |
2423195 | 2423195 | 2022-04-19 | Mineral | Nevada | 32021 | 1262 | 17 |
2424550 | 2424550 | 2022-04-19 | Mineral | West Virginia | 54057 | 7861 | 156 |
Advanced export
JSON shape: default, array, newline-delimited
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);