ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Isabela" and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501950 | 2501950 | 2022-05-13 | Isabela | Puerto Rico | 72071 | 7653 | |
2498692 | 2498692 | 2022-05-12 | Isabela | Puerto Rico | 72071 | 7631 | |
2495434 | 2495434 | 2022-05-11 | Isabela | Puerto Rico | 72071 | 7560 | |
2492176 | 2492176 | 2022-05-10 | Isabela | Puerto Rico | 72071 | 7483 | |
2488918 | 2488918 | 2022-05-09 | Isabela | Puerto Rico | 72071 | 7481 | |
2485661 | 2485661 | 2022-05-08 | Isabela | Puerto Rico | 72071 | 7382 | |
2482403 | 2482403 | 2022-05-07 | Isabela | Puerto Rico | 72071 | 7383 | |
2479145 | 2479145 | 2022-05-06 | Isabela | Puerto Rico | 72071 | 7340 | |
2475887 | 2475887 | 2022-05-05 | Isabela | Puerto Rico | 72071 | 7275 | |
2472630 | 2472630 | 2022-05-04 | Isabela | Puerto Rico | 72071 | 7235 | |
2469374 | 2469374 | 2022-05-03 | Isabela | Puerto Rico | 72071 | 7168 | |
2466118 | 2466118 | 2022-05-02 | Isabela | Puerto Rico | 72071 | 7137 | |
2462863 | 2462863 | 2022-05-01 | Isabela | Puerto Rico | 72071 | 7121 | |
2459607 | 2459607 | 2022-04-30 | Isabela | Puerto Rico | 72071 | 7055 | |
2456351 | 2456351 | 2022-04-29 | Isabela | Puerto Rico | 72071 | 7000 | |
2453095 | 2453095 | 2022-04-28 | Isabela | Puerto Rico | 72071 | 6935 | |
2449839 | 2449839 | 2022-04-27 | Isabela | Puerto Rico | 72071 | 6905 | |
2446582 | 2446582 | 2022-04-26 | Isabela | Puerto Rico | 72071 | 6865 | |
2443327 | 2443327 | 2022-04-25 | Isabela | Puerto Rico | 72071 | 6859 | |
2440071 | 2440071 | 2022-04-24 | Isabela | Puerto Rico | 72071 | 6841 | |
2436815 | 2436815 | 2022-04-23 | Isabela | Puerto Rico | 72071 | 6798 | |
2433559 | 2433559 | 2022-04-22 | Isabela | Puerto Rico | 72071 | 6754 | |
2430303 | 2430303 | 2022-04-21 | Isabela | Puerto Rico | 72071 | 6681 | |
2427047 | 2427047 | 2022-04-20 | Isabela | Puerto Rico | 72071 | 6650 | |
2423791 | 2423791 | 2022-04-19 | Isabela | Puerto Rico | 72071 | 6639 | |
2420535 | 2420535 | 2022-04-18 | Isabela | Puerto Rico | 72071 | 6639 | |
2417279 | 2417279 | 2022-04-17 | Isabela | Puerto Rico | 72071 | 6634 | |
2414023 | 2414023 | 2022-04-16 | Isabela | Puerto Rico | 72071 | 6600 | |
2410767 | 2410767 | 2022-04-15 | Isabela | Puerto Rico | 72071 | 6600 | |
2407511 | 2407511 | 2022-04-14 | Isabela | Puerto Rico | 72071 | 6600 | |
2404255 | 2404255 | 2022-04-13 | Isabela | Puerto Rico | 72071 | 6573 | |
2401000 | 2401000 | 2022-04-12 | Isabela | Puerto Rico | 72071 | 6546 | |
2397745 | 2397745 | 2022-04-11 | Isabela | Puerto Rico | 72071 | 6544 | |
2394490 | 2394490 | 2022-04-10 | Isabela | Puerto Rico | 72071 | 6541 | |
2391234 | 2391234 | 2022-04-09 | Isabela | Puerto Rico | 72071 | 6532 | |
2387978 | 2387978 | 2022-04-08 | Isabela | Puerto Rico | 72071 | 6528 | |
2384723 | 2384723 | 2022-04-07 | Isabela | Puerto Rico | 72071 | 6524 | |
2381468 | 2381468 | 2022-04-06 | Isabela | Puerto Rico | 72071 | 6518 | |
2378213 | 2378213 | 2022-04-05 | Isabela | Puerto Rico | 72071 | 6510 | |
2374959 | 2374959 | 2022-04-04 | Isabela | Puerto Rico | 72071 | 6507 | |
2371707 | 2371707 | 2022-04-03 | Isabela | Puerto Rico | 72071 | 6506 | |
2368454 | 2368454 | 2022-04-02 | Isabela | Puerto Rico | 72071 | 6501 | |
2365201 | 2365201 | 2022-04-01 | Isabela | Puerto Rico | 72071 | 6499 | |
2361948 | 2361948 | 2022-03-31 | Isabela | Puerto Rico | 72071 | 6490 | |
2358694 | 2358694 | 2022-03-30 | Isabela | Puerto Rico | 72071 | 6488 | |
2355440 | 2355440 | 2022-03-29 | Isabela | Puerto Rico | 72071 | 6480 | |
2352187 | 2352187 | 2022-03-28 | Isabela | Puerto Rico | 72071 | 6478 | |
2348935 | 2348935 | 2022-03-27 | Isabela | Puerto Rico | 72071 | 6476 | |
2345682 | 2345682 | 2022-03-26 | Isabela | Puerto Rico | 72071 | 6474 | |
2342429 | 2342429 | 2022-03-25 | Isabela | Puerto Rico | 72071 | 6468 | |
2339176 | 2339176 | 2022-03-24 | Isabela | Puerto Rico | 72071 | 6467 | |
2335922 | 2335922 | 2022-03-23 | Isabela | Puerto Rico | 72071 | 6467 | |
2332668 | 2332668 | 2022-03-22 | Isabela | Puerto Rico | 72071 | 6463 | |
2329415 | 2329415 | 2022-03-21 | Isabela | Puerto Rico | 72071 | 6463 | |
2326163 | 2326163 | 2022-03-20 | Isabela | Puerto Rico | 72071 | 6461 | |
2322910 | 2322910 | 2022-03-19 | Isabela | Puerto Rico | 72071 | 6460 | |
2319656 | 2319656 | 2022-03-18 | Isabela | Puerto Rico | 72071 | 6459 | |
2316402 | 2316402 | 2022-03-17 | Isabela | Puerto Rico | 72071 | 6458 | |
2313149 | 2313149 | 2022-03-16 | Isabela | Puerto Rico | 72071 | 6449 | |
2309896 | 2309896 | 2022-03-15 | Isabela | Puerto Rico | 72071 | 6447 | |
2306643 | 2306643 | 2022-03-14 | Isabela | Puerto Rico | 72071 | 6446 | |
2303392 | 2303392 | 2022-03-13 | Isabela | Puerto Rico | 72071 | 6445 | |
2300140 | 2300140 | 2022-03-12 | Isabela | Puerto Rico | 72071 | 6442 | |
2296888 | 2296888 | 2022-03-11 | Isabela | Puerto Rico | 72071 | 6442 | |
2293636 | 2293636 | 2022-03-10 | Isabela | Puerto Rico | 72071 | 6439 | |
2290384 | 2290384 | 2022-03-09 | Isabela | Puerto Rico | 72071 | 6438 | |
2287132 | 2287132 | 2022-03-08 | Isabela | Puerto Rico | 72071 | 6436 | |
2283880 | 2283880 | 2022-03-07 | Isabela | Puerto Rico | 72071 | 6436 | |
2280628 | 2280628 | 2022-03-06 | Isabela | Puerto Rico | 72071 | 6434 | |
2277375 | 2277375 | 2022-03-05 | Isabela | Puerto Rico | 72071 | 6432 | |
2274122 | 2274122 | 2022-03-04 | Isabela | Puerto Rico | 72071 | 6428 | |
2270869 | 2270869 | 2022-03-03 | Isabela | Puerto Rico | 72071 | 6422 | |
2267617 | 2267617 | 2022-03-02 | Isabela | Puerto Rico | 72071 | 6418 | |
2264364 | 2264364 | 2022-03-01 | Isabela | Puerto Rico | 72071 | 6414 | |
2261114 | 2261114 | 2022-02-28 | Isabela | Puerto Rico | 72071 | 6414 | |
2257863 | 2257863 | 2022-02-27 | Isabela | Puerto Rico | 72071 | 6411 | |
2254612 | 2254612 | 2022-02-26 | Isabela | Puerto Rico | 72071 | 6409 | |
2251361 | 2251361 | 2022-02-25 | Isabela | Puerto Rico | 72071 | 6405 | |
2248110 | 2248110 | 2022-02-24 | Isabela | Puerto Rico | 72071 | 6404 | |
2244859 | 2244859 | 2022-02-23 | Isabela | Puerto Rico | 72071 | 6398 | |
2241608 | 2241608 | 2022-02-22 | Isabela | Puerto Rico | 72071 | 6395 | |
2238357 | 2238357 | 2022-02-21 | Isabela | Puerto Rico | 72071 | 6395 | |
2235106 | 2235106 | 2022-02-20 | Isabela | Puerto Rico | 72071 | 6387 | |
2231855 | 2231855 | 2022-02-19 | Isabela | Puerto Rico | 72071 | 6380 | |
2228604 | 2228604 | 2022-02-18 | Isabela | Puerto Rico | 72071 | 6373 | |
2225353 | 2225353 | 2022-02-17 | Isabela | Puerto Rico | 72071 | 6362 | |
2222102 | 2222102 | 2022-02-16 | Isabela | Puerto Rico | 72071 | 6353 | |
2218851 | 2218851 | 2022-02-15 | Isabela | Puerto Rico | 72071 | 6320 | |
2215600 | 2215600 | 2022-02-14 | Isabela | Puerto Rico | 72071 | 6321 | |
2212349 | 2212349 | 2022-02-13 | Isabela | Puerto Rico | 72071 | 6319 | |
2209096 | 2209096 | 2022-02-12 | Isabela | Puerto Rico | 72071 | 6300 | |
2205843 | 2205843 | 2022-02-11 | Isabela | Puerto Rico | 72071 | 6298 | |
2202590 | 2202590 | 2022-02-10 | Isabela | Puerto Rico | 72071 | 6289 | |
2199336 | 2199336 | 2022-02-09 | Isabela | Puerto Rico | 72071 | 6261 | |
2196082 | 2196082 | 2022-02-08 | Isabela | Puerto Rico | 72071 | 6251 | |
2192828 | 2192828 | 2022-02-07 | Isabela | Puerto Rico | 72071 | 6249 | |
2189574 | 2189574 | 2022-02-06 | Isabela | Puerto Rico | 72071 | 6249 | |
2186321 | 2186321 | 2022-02-05 | Isabela | Puerto Rico | 72071 | 6207 | |
2183069 | 2183069 | 2022-02-04 | Isabela | Puerto Rico | 72071 | 6205 | |
2179817 | 2179817 | 2022-02-03 | Isabela | Puerto Rico | 72071 | 6185 |
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);