us-counties-recent

Table actions
Big Local News snapshots this data daily from https://github.com/nytimes/covid-19-data. This is time series data for U.S. confirmed cases and deaths down to the county level. There are three CSV files released once a day: national-level data, state-level data and county-level data. Each file contains date, county/state name, FIPS code, number of confirmed cases, number of deaths going back to January 21. All data is gathered by New York Times reporters from state and local health departments or official government announcements. The data is updated once a day in the morning, usually around 8 a.m. EDT, with a full day’s worth of data from the day before. Please cite the New York Times as described in the README and check terms of use.

Data source: Big Local News · About: big-local-datasette

94,127 rows sorted by deaths

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid date county state fips cases deaths ▼
2331 2331 2021-01-31 Adjuntas Puerto Rico 72001 452  
2332 2332 2021-01-31 Aguada Puerto Rico 72003 1109  
2333 2333 2021-01-31 Aguadilla Puerto Rico 72005 1402  
2334 2334 2021-01-31 Aguas Buenas Puerto Rico 72007 954  
2335 2335 2021-01-31 Aibonito Puerto Rico 72009 549  
2336 2336 2021-01-31 Anasco Puerto Rico 72011 759  
2337 2337 2021-01-31 Arecibo Puerto Rico 72013 2695  
2338 2338 2021-01-31 Arroyo Puerto Rico 72015 346  
2339 2339 2021-01-31 Barceloneta Puerto Rico 72017 688  
2340 2340 2021-01-31 Barranquitas Puerto Rico 72019 1146  
2341 2341 2021-01-31 Bayamon Puerto Rico 72021 9600  
2342 2342 2021-01-31 Cabo Rojo Puerto Rico 72023 867  
2343 2343 2021-01-31 Caguas Puerto Rico 72025 5289  
2344 2344 2021-01-31 Camuy Puerto Rico 72027 1038  
2345 2345 2021-01-31 Canovanas Puerto Rico 72029 1696  
2346 2346 2021-01-31 Carolina Puerto Rico 72031 7582  
2347 2347 2021-01-31 Catano Puerto Rico 72033 1174  
2348 2348 2021-01-31 Cayey Puerto Rico 72035 1245  
2349 2349 2021-01-31 Ceiba Puerto Rico 72037 379  
2350 2350 2021-01-31 Ciales Puerto Rico 72039 703  
2351 2351 2021-01-31 Cidra Puerto Rico 72041 1161  
2352 2352 2021-01-31 Coamo Puerto Rico 72043 915  
2353 2353 2021-01-31 Comerio Puerto Rico 72045 668  
2354 2354 2021-01-31 Corozal Puerto Rico 72047 1566  
2355 2355 2021-01-31 Culebra Puerto Rico 72049 28  
2356 2356 2021-01-31 Dorado Puerto Rico 72051 2073  
2357 2357 2021-01-31 Fajardo Puerto Rico 72053 1224  
2358 2358 2021-01-31 Florida Puerto Rico 72054 660  
2359 2359 2021-01-31 Guanica Puerto Rico 72055 238  
2360 2360 2021-01-31 Guayama Puerto Rico 72057 774  
2361 2361 2021-01-31 Guayanilla Puerto Rico 72059 398  
2362 2362 2021-01-31 Guaynabo Puerto Rico 72061 4195  
2363 2363 2021-01-31 Gurabo Puerto Rico 72063 1671  
2364 2364 2021-01-31 Hatillo Puerto Rico 72065 958  
2365 2365 2021-01-31 Hormigueros Puerto Rico 72067 389  
2366 2366 2021-01-31 Humacao Puerto Rico 72069 1552  
2367 2367 2021-01-31 Isabela Puerto Rico 72071 1139  
2368 2368 2021-01-31 Jayuya Puerto Rico 72073 389  
2369 2369 2021-01-31 Juana Diaz Puerto Rico 72075 1027  
2370 2370 2021-01-31 Juncos Puerto Rico 72077 1579  
2371 2371 2021-01-31 Lajas Puerto Rico 72079 366  
2372 2372 2021-01-31 Lares Puerto Rico 72081 835  
2373 2373 2021-01-31 Las Marias Puerto Rico 72083 195  
2374 2374 2021-01-31 Las Piedras Puerto Rico 72085 1310  
2375 2375 2021-01-31 Loiza Puerto Rico 72087 925  
2376 2376 2021-01-31 Luquillo Puerto Rico 72089 623  
2377 2377 2021-01-31 Manati Puerto Rico 72091 1501  
2378 2378 2021-01-31 Maricao Puerto Rico 72093 109  
2379 2379 2021-01-31 Maunabo Puerto Rico 72095 316  
2380 2380 2021-01-31 Mayaguez Puerto Rico 72097 1821  
2381 2381 2021-01-31 Moca Puerto Rico 72099 1326  
2382 2382 2021-01-31 Morovis Puerto Rico 72101 1275  
2383 2383 2021-01-31 Naguabo Puerto Rico 72103 720  
2384 2384 2021-01-31 Naranjito Puerto Rico 72105 1516  
2385 2385 2021-01-31 Orocovis Puerto Rico 72107 768  
2386 2386 2021-01-31 Patillas Puerto Rico 72109 347  
2387 2387 2021-01-31 Penuelas Puerto Rico 72111 479  
2388 2388 2021-01-31 Ponce Puerto Rico 72113 2822  
2389 2389 2021-01-31 Quebradillas Puerto Rico 72115 669  
2390 2390 2021-01-31 Rincon Puerto Rico 72117 413  
2391 2391 2021-01-31 Rio Grande Puerto Rico 72119 1691  
2392 2392 2021-01-31 Sabana Grande Puerto Rico 72121 380  
2393 2393 2021-01-31 Salinas Puerto Rico 72123 988  
2394 2394 2021-01-31 San German Puerto Rico 72125 585  
2395 2395 2021-01-31 San Juan Puerto Rico 72127 17267  
2396 2396 2021-01-31 San Lorenzo Puerto Rico 72129 1380  
2397 2397 2021-01-31 San Sebastian Puerto Rico 72131 1607  
2398 2398 2021-01-31 Santa Isabel Puerto Rico 72133 528  
2399 2399 2021-01-31 Toa Alta Puerto Rico 72135 3499  
2400 2400 2021-01-31 Toa Baja Puerto Rico 72137 3676  
2401 2401 2021-01-31 Trujillo Alto Puerto Rico 72139 2758  
2403 2403 2021-01-31 Utuado Puerto Rico 72141 820  
2404 2404 2021-01-31 Vega Alta Puerto Rico 72143 1754  
2405 2405 2021-01-31 Vega Baja Puerto Rico 72145 2578  
2406 2406 2021-01-31 Vieques Puerto Rico 72147 194  
2407 2407 2021-01-31 Villalba Puerto Rico 72149 716  
2408 2408 2021-01-31 Yabucoa Puerto Rico 72151 934  
2409 2409 2021-01-31 Yauco Puerto Rico 72153 974  
5578 5578 2021-02-01 Adjuntas Puerto Rico 72001 452  
5579 5579 2021-02-01 Aguada Puerto Rico 72003 1115  
5580 5580 2021-02-01 Aguadilla Puerto Rico 72005 1407  
5581 5581 2021-02-01 Aguas Buenas Puerto Rico 72007 966  
5582 5582 2021-02-01 Aibonito Puerto Rico 72009 555  
5583 5583 2021-02-01 Anasco Puerto Rico 72011 769  
5584 5584 2021-02-01 Arecibo Puerto Rico 72013 2707  
5585 5585 2021-02-01 Arroyo Puerto Rico 72015 346  
5586 5586 2021-02-01 Barceloneta Puerto Rico 72017 691  
5587 5587 2021-02-01 Barranquitas Puerto Rico 72019 1163  
5588 5588 2021-02-01 Bayamon Puerto Rico 72021 9650  
5589 5589 2021-02-01 Cabo Rojo Puerto Rico 72023 869  
5590 5590 2021-02-01 Caguas Puerto Rico 72025 5325  
5591 5591 2021-02-01 Camuy Puerto Rico 72027 1043  
5592 5592 2021-02-01 Canovanas Puerto Rico 72029 1701  
5593 5593 2021-02-01 Carolina Puerto Rico 72031 7613  
5594 5594 2021-02-01 Catano Puerto Rico 72033 1178  
5595 5595 2021-02-01 Cayey Puerto Rico 72035 1248  
5596 5596 2021-02-01 Ceiba Puerto Rico 72037 383  
5597 5597 2021-02-01 Ciales Puerto Rico 72039 710  
5598 5598 2021-02-01 Cidra Puerto Rico 72041 1166  
5599 5599 2021-02-01 Coamo Puerto Rico 72043 917  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [us-counties-recent] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);