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

784 rows where fips = 30013 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 30013 · 784 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501199 2501199 2022-05-13 Cascade Montana 30013 25246 341
2497941 2497941 2022-05-12 Cascade Montana 30013 25219 341
2494683 2494683 2022-05-11 Cascade Montana 30013 25219 341
2491425 2491425 2022-05-10 Cascade Montana 30013 25219 341
2488167 2488167 2022-05-09 Cascade Montana 30013 25219 341
2484910 2484910 2022-05-08 Cascade Montana 30013 25219 341
2481652 2481652 2022-05-07 Cascade Montana 30013 25219 341
2478394 2478394 2022-05-06 Cascade Montana 30013 25219 341
2475136 2475136 2022-05-05 Cascade Montana 30013 25217 341
2471879 2471879 2022-05-04 Cascade Montana 30013 25214 341
2468623 2468623 2022-05-03 Cascade Montana 30013 25211 341
2465367 2465367 2022-05-02 Cascade Montana 30013 25210 341
2462112 2462112 2022-05-01 Cascade Montana 30013 25205 341
2458856 2458856 2022-04-30 Cascade Montana 30013 25205 341
2455600 2455600 2022-04-29 Cascade Montana 30013 25205 341
2452344 2452344 2022-04-28 Cascade Montana 30013 25215 341
2449088 2449088 2022-04-27 Cascade Montana 30013 25184 341
2445831 2445831 2022-04-26 Cascade Montana 30013 25169 341
2442576 2442576 2022-04-25 Cascade Montana 30013 25160 332
2439320 2439320 2022-04-24 Cascade Montana 30013 25157 323
2436064 2436064 2022-04-23 Cascade Montana 30013 25157 323
2432808 2432808 2022-04-22 Cascade Montana 30013 25157 323
2429552 2429552 2022-04-21 Cascade Montana 30013 25155 323
2426296 2426296 2022-04-20 Cascade Montana 30013 25156 323
2423040 2423040 2022-04-19 Cascade Montana 30013 25152 323
2419783 2419783 2022-04-18 Cascade Montana 30013 25145 323
2416528 2416528 2022-04-17 Cascade Montana 30013 25142 323
2413272 2413272 2022-04-16 Cascade Montana 30013 25142 323
2410016 2410016 2022-04-15 Cascade Montana 30013 25142 323
2406760 2406760 2022-04-14 Cascade Montana 30013 25136 323
2403504 2403504 2022-04-13 Cascade Montana 30013 25134 322
2400249 2400249 2022-04-12 Cascade Montana 30013 25134 322
2396994 2396994 2022-04-11 Cascade Montana 30013 25131 321
2393739 2393739 2022-04-10 Cascade Montana 30013 25128 321
2390483 2390483 2022-04-09 Cascade Montana 30013 25128 321
2387227 2387227 2022-04-08 Cascade Montana 30013 25128 321
2383972 2383972 2022-04-07 Cascade Montana 30013 25127 321
2380717 2380717 2022-04-06 Cascade Montana 30013 25120 321
2377462 2377462 2022-04-05 Cascade Montana 30013 25118 321
2374209 2374209 2022-04-04 Cascade Montana 30013 25111 321
2370957 2370957 2022-04-03 Cascade Montana 30013 25108 321
2367704 2367704 2022-04-02 Cascade Montana 30013 25108 321
2364451 2364451 2022-04-01 Cascade Montana 30013 25108 321
2361197 2361197 2022-03-31 Cascade Montana 30013 25108 321
2357943 2357943 2022-03-30 Cascade Montana 30013 25106 321
2354690 2354690 2022-03-29 Cascade Montana 30013 25103 321
2351437 2351437 2022-03-28 Cascade Montana 30013 25100 321
2348185 2348185 2022-03-27 Cascade Montana 30013 25097 321
2344932 2344932 2022-03-26 Cascade Montana 30013 25097 321
2341679 2341679 2022-03-25 Cascade Montana 30013 25097 321
2338426 2338426 2022-03-24 Cascade Montana 30013 25091 321
2335172 2335172 2022-03-23 Cascade Montana 30013 25091 321
2331918 2331918 2022-03-22 Cascade Montana 30013 25085 320
2328665 2328665 2022-03-21 Cascade Montana 30013 25081 320
2325413 2325413 2022-03-20 Cascade Montana 30013 25078 320
2322159 2322159 2022-03-19 Cascade Montana 30013 25078 320
2318905 2318905 2022-03-18 Cascade Montana 30013 25078 320
2315652 2315652 2022-03-17 Cascade Montana 30013 25068 320
2312399 2312399 2022-03-16 Cascade Montana 30013 25063 319
2309146 2309146 2022-03-15 Cascade Montana 30013 25058 319
2305894 2305894 2022-03-14 Cascade Montana 30013 25051 319
2302643 2302643 2022-03-13 Cascade Montana 30013 25044 319
2299391 2299391 2022-03-12 Cascade Montana 30013 25044 319
2296139 2296139 2022-03-11 Cascade Montana 30013 25044 319
2292887 2292887 2022-03-10 Cascade Montana 30013 25042 319
2289635 2289635 2022-03-09 Cascade Montana 30013 25004 313
2286383 2286383 2022-03-08 Cascade Montana 30013 24982 314
2283131 2283131 2022-03-07 Cascade Montana 30013 24967 314
2279878 2279878 2022-03-06 Cascade Montana 30013 24954 314
2276625 2276625 2022-03-05 Cascade Montana 30013 24954 314
2273372 2273372 2022-03-04 Cascade Montana 30013 24954 314
2270120 2270120 2022-03-03 Cascade Montana 30013 24823 314
2266867 2266867 2022-03-02 Cascade Montana 30013 24753 314
2263616 2263616 2022-03-01 Cascade Montana 30013 24623 314
2260365 2260365 2022-02-28 Cascade Montana 30013 24401 312
2257114 2257114 2022-02-27 Cascade Montana 30013 24274 312
2253863 2253863 2022-02-26 Cascade Montana 30013 24274 312
2250612 2250612 2022-02-25 Cascade Montana 30013 24274 312
2247361 2247361 2022-02-24 Cascade Montana 30013 24053 311
2244110 2244110 2022-02-23 Cascade Montana 30013 23869 310
2240859 2240859 2022-02-22 Cascade Montana 30013 23717 310
2237608 2237608 2022-02-21 Cascade Montana 30013 23589 309
2234357 2234357 2022-02-20 Cascade Montana 30013 23589 309
2231106 2231106 2022-02-19 Cascade Montana 30013 23589 309
2227855 2227855 2022-02-18 Cascade Montana 30013 23589 309
2224604 2224604 2022-02-17 Cascade Montana 30013 23427 309
2221353 2221353 2022-02-16 Cascade Montana 30013 23200 308
2218102 2218102 2022-02-15 Cascade Montana 30013 22971 304
2214851 2214851 2022-02-14 Cascade Montana 30013 22778 300
2211599 2211599 2022-02-13 Cascade Montana 30013 22524 300
2208346 2208346 2022-02-12 Cascade Montana 30013 22524 300
2205093 2205093 2022-02-11 Cascade Montana 30013 22524 300
2201840 2201840 2022-02-10 Cascade Montana 30013 22317 297
2198586 2198586 2022-02-09 Cascade Montana 30013 22181 296
2195332 2195332 2022-02-08 Cascade Montana 30013 22030 295
2192078 2192078 2022-02-07 Cascade Montana 30013 21844 294
2188825 2188825 2022-02-06 Cascade Montana 30013 21715 294
2185572 2185572 2022-02-05 Cascade Montana 30013 21715 294
2182320 2182320 2022-02-04 Cascade Montana 30013 21715 294
2179068 2179068 2022-02-03 Cascade Montana 30013 21040 293

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