ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,822 rows where county = "San Juan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 5
- Washington 765
- New Mexico 763
- Utah 757
- Puerto Rico 719
- Colorado 718
county 1
- San Juan · 3,722 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2434741 | 2434741 | 2022-04-23 | San Juan | Colorado | 8111 | 202 | 0 |
2436282 | 2436282 | 2022-04-23 | San Juan | New Mexico | 35045 | 40777 | 745 |
2436843 | 2436843 | 2022-04-23 | San Juan | Puerto Rico | 72127 | 61993 | |
2437344 | 2437344 | 2022-04-23 | San Juan | Utah | 49037 | 3983 | 48 |
2437534 | 2437534 | 2022-04-23 | San Juan | Washington | 53055 | 1237 | 2 |
2431485 | 2431485 | 2022-04-22 | San Juan | Colorado | 8111 | 202 | 0 |
2433026 | 2433026 | 2022-04-22 | San Juan | New Mexico | 35045 | 40777 | 745 |
2433587 | 2433587 | 2022-04-22 | San Juan | Puerto Rico | 72127 | 61723 | |
2434088 | 2434088 | 2022-04-22 | San Juan | Utah | 49037 | 3983 | 48 |
2434278 | 2434278 | 2022-04-22 | San Juan | Washington | 53055 | 1237 | 2 |
2428229 | 2428229 | 2022-04-21 | San Juan | Colorado | 8111 | 202 | 0 |
2429770 | 2429770 | 2022-04-21 | San Juan | New Mexico | 35045 | 40771 | 745 |
2430331 | 2430331 | 2022-04-21 | San Juan | Puerto Rico | 72127 | 61374 | |
2430832 | 2430832 | 2022-04-21 | San Juan | Utah | 49037 | 3983 | 48 |
2431022 | 2431022 | 2022-04-21 | San Juan | Washington | 53055 | 1225 | 2 |
2424973 | 2424973 | 2022-04-20 | San Juan | Colorado | 8111 | 202 | 0 |
2426514 | 2426514 | 2022-04-20 | San Juan | New Mexico | 35045 | 40765 | 744 |
2427075 | 2427075 | 2022-04-20 | San Juan | Puerto Rico | 72127 | 61081 | |
2427576 | 2427576 | 2022-04-20 | San Juan | Utah | 49037 | 3981 | 48 |
2427766 | 2427766 | 2022-04-20 | San Juan | Washington | 53055 | 1225 | 2 |
2421717 | 2421717 | 2022-04-19 | San Juan | Colorado | 8111 | 202 | 0 |
2423258 | 2423258 | 2022-04-19 | San Juan | New Mexico | 35045 | 40760 | 744 |
2423819 | 2423819 | 2022-04-19 | San Juan | Puerto Rico | 72127 | 60947 | |
2424320 | 2424320 | 2022-04-19 | San Juan | Utah | 49037 | 3981 | 48 |
2424510 | 2424510 | 2022-04-19 | San Juan | Washington | 53055 | 1221 | 2 |
2418461 | 2418461 | 2022-04-18 | San Juan | Colorado | 8111 | 201 | 0 |
2420001 | 2420001 | 2022-04-18 | San Juan | New Mexico | 35045 | 40755 | 744 |
2420563 | 2420563 | 2022-04-18 | San Juan | Puerto Rico | 72127 | 60934 | |
2421064 | 2421064 | 2022-04-18 | San Juan | Utah | 49037 | 3981 | 48 |
2421254 | 2421254 | 2022-04-18 | San Juan | Washington | 53055 | 1221 | 2 |
2415205 | 2415205 | 2022-04-17 | San Juan | Colorado | 8111 | 201 | 0 |
2416746 | 2416746 | 2022-04-17 | San Juan | New Mexico | 35045 | 40744 | 744 |
2417307 | 2417307 | 2022-04-17 | San Juan | Puerto Rico | 72127 | 60858 | |
2417808 | 2417808 | 2022-04-17 | San Juan | Utah | 49037 | 3981 | 48 |
2417998 | 2417998 | 2022-04-17 | San Juan | Washington | 53055 | 1215 | 2 |
2411949 | 2411949 | 2022-04-16 | San Juan | Colorado | 8111 | 201 | 0 |
2413490 | 2413490 | 2022-04-16 | San Juan | New Mexico | 35045 | 40744 | 744 |
2414051 | 2414051 | 2022-04-16 | San Juan | Puerto Rico | 72127 | 60494 | |
2414552 | 2414552 | 2022-04-16 | San Juan | Utah | 49037 | 3981 | 48 |
2414742 | 2414742 | 2022-04-16 | San Juan | Washington | 53055 | 1215 | 2 |
2408693 | 2408693 | 2022-04-15 | San Juan | Colorado | 8111 | 201 | 0 |
2410234 | 2410234 | 2022-04-15 | San Juan | New Mexico | 35045 | 40744 | 744 |
2410795 | 2410795 | 2022-04-15 | San Juan | Puerto Rico | 72127 | 60494 | |
2411296 | 2411296 | 2022-04-15 | San Juan | Utah | 49037 | 3981 | 48 |
2411486 | 2411486 | 2022-04-15 | San Juan | Washington | 53055 | 1215 | 2 |
2405437 | 2405437 | 2022-04-14 | San Juan | Colorado | 8111 | 201 | 0 |
2406978 | 2406978 | 2022-04-14 | San Juan | New Mexico | 35045 | 40739 | 744 |
2407539 | 2407539 | 2022-04-14 | San Juan | Puerto Rico | 72127 | 60494 | |
2408040 | 2408040 | 2022-04-14 | San Juan | Utah | 49037 | 3981 | 48 |
2408230 | 2408230 | 2022-04-14 | San Juan | Washington | 53055 | 1211 | 2 |
2402182 | 2402182 | 2022-04-13 | San Juan | Colorado | 8111 | 201 | 0 |
2403722 | 2403722 | 2022-04-13 | San Juan | New Mexico | 35045 | 40736 | 744 |
2404283 | 2404283 | 2022-04-13 | San Juan | Puerto Rico | 72127 | 60356 | |
2404784 | 2404784 | 2022-04-13 | San Juan | Utah | 49037 | 3979 | 48 |
2404974 | 2404974 | 2022-04-13 | San Juan | Washington | 53055 | 1211 | 2 |
2398927 | 2398927 | 2022-04-12 | San Juan | Colorado | 8111 | 201 | 0 |
2400467 | 2400467 | 2022-04-12 | San Juan | New Mexico | 35045 | 40732 | 744 |
2401028 | 2401028 | 2022-04-12 | San Juan | Puerto Rico | 72127 | 60260 | |
2401529 | 2401529 | 2022-04-12 | San Juan | Utah | 49037 | 3979 | 48 |
2401719 | 2401719 | 2022-04-12 | San Juan | Washington | 53055 | 1210 | 2 |
2395672 | 2395672 | 2022-04-11 | San Juan | Colorado | 8111 | 200 | 0 |
2397212 | 2397212 | 2022-04-11 | San Juan | New Mexico | 35045 | 40728 | 744 |
2397773 | 2397773 | 2022-04-11 | San Juan | Puerto Rico | 72127 | 60256 | |
2398274 | 2398274 | 2022-04-11 | San Juan | Utah | 49037 | 3979 | 48 |
2398464 | 2398464 | 2022-04-11 | San Juan | Washington | 53055 | 1210 | 2 |
2392416 | 2392416 | 2022-04-10 | San Juan | Colorado | 8111 | 200 | 0 |
2393957 | 2393957 | 2022-04-10 | San Juan | New Mexico | 35045 | 40717 | 744 |
2394518 | 2394518 | 2022-04-10 | San Juan | Puerto Rico | 72127 | 60180 | |
2395019 | 2395019 | 2022-04-10 | San Juan | Utah | 49037 | 3979 | 48 |
2395209 | 2395209 | 2022-04-10 | San Juan | Washington | 53055 | 1210 | 2 |
2389160 | 2389160 | 2022-04-09 | San Juan | Colorado | 8111 | 200 | 0 |
2390701 | 2390701 | 2022-04-09 | San Juan | New Mexico | 35045 | 40717 | 744 |
2391262 | 2391262 | 2022-04-09 | San Juan | Puerto Rico | 72127 | 60067 | |
2391763 | 2391763 | 2022-04-09 | San Juan | Utah | 49037 | 3979 | 48 |
2391953 | 2391953 | 2022-04-09 | San Juan | Washington | 53055 | 1210 | 2 |
2385905 | 2385905 | 2022-04-08 | San Juan | Colorado | 8111 | 200 | 0 |
2387445 | 2387445 | 2022-04-08 | San Juan | New Mexico | 35045 | 40717 | 744 |
2388006 | 2388006 | 2022-04-08 | San Juan | Puerto Rico | 72127 | 60005 | |
2388507 | 2388507 | 2022-04-08 | San Juan | Utah | 49037 | 3979 | 48 |
2388697 | 2388697 | 2022-04-08 | San Juan | Washington | 53055 | 1210 | 2 |
2382650 | 2382650 | 2022-04-07 | San Juan | Colorado | 8111 | 200 | 0 |
2384190 | 2384190 | 2022-04-07 | San Juan | New Mexico | 35045 | 40709 | 744 |
2384751 | 2384751 | 2022-04-07 | San Juan | Puerto Rico | 72127 | 59926 | |
2385252 | 2385252 | 2022-04-07 | San Juan | Utah | 49037 | 3979 | 48 |
2385442 | 2385442 | 2022-04-07 | San Juan | Washington | 53055 | 1210 | 2 |
2379395 | 2379395 | 2022-04-06 | San Juan | Colorado | 8111 | 200 | 0 |
2380935 | 2380935 | 2022-04-06 | San Juan | New Mexico | 35045 | 40705 | 744 |
2381496 | 2381496 | 2022-04-06 | San Juan | Puerto Rico | 72127 | 59838 | |
2381997 | 2381997 | 2022-04-06 | San Juan | Utah | 49037 | 3976 | 48 |
2382187 | 2382187 | 2022-04-06 | San Juan | Washington | 53055 | 1210 | 2 |
2376141 | 2376141 | 2022-04-05 | San Juan | Colorado | 8111 | 199 | 0 |
2377680 | 2377680 | 2022-04-05 | San Juan | New Mexico | 35045 | 40700 | 744 |
2378241 | 2378241 | 2022-04-05 | San Juan | Puerto Rico | 72127 | 59792 | |
2378742 | 2378742 | 2022-04-05 | San Juan | Utah | 49037 | 3976 | 48 |
2378932 | 2378932 | 2022-04-05 | San Juan | Washington | 53055 | 1207 | 2 |
2372889 | 2372889 | 2022-04-04 | San Juan | Colorado | 8111 | 199 | 0 |
2374427 | 2374427 | 2022-04-04 | San Juan | New Mexico | 35045 | 40698 | 742 |
2374987 | 2374987 | 2022-04-04 | San Juan | Puerto Rico | 72127 | 59786 | |
2375488 | 2375488 | 2022-04-04 | San Juan | Utah | 49037 | 3976 | 48 |
2375678 | 2375678 | 2022-04-04 | San Juan | Washington | 53055 | 1207 | 2 |
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);