ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Mayaguez" and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498705 | 2498705 | 2022-05-12 | Mayaguez | Puerto Rico | 72097 | 11704 | |
2495447 | 2495447 | 2022-05-11 | Mayaguez | Puerto Rico | 72097 | 11529 | |
2492189 | 2492189 | 2022-05-10 | Mayaguez | Puerto Rico | 72097 | 11424 | |
2488931 | 2488931 | 2022-05-09 | Mayaguez | Puerto Rico | 72097 | 11401 | |
2485674 | 2485674 | 2022-05-08 | Mayaguez | Puerto Rico | 72097 | 11212 | |
2482416 | 2482416 | 2022-05-07 | Mayaguez | Puerto Rico | 72097 | 11210 | |
2479158 | 2479158 | 2022-05-06 | Mayaguez | Puerto Rico | 72097 | 11091 | |
2475900 | 2475900 | 2022-05-05 | Mayaguez | Puerto Rico | 72097 | 10973 | |
2472643 | 2472643 | 2022-05-04 | Mayaguez | Puerto Rico | 72097 | 10855 | |
2469387 | 2469387 | 2022-05-03 | Mayaguez | Puerto Rico | 72097 | 10774 | |
2466131 | 2466131 | 2022-05-02 | Mayaguez | Puerto Rico | 72097 | 10759 | |
2462876 | 2462876 | 2022-05-01 | Mayaguez | Puerto Rico | 72097 | 10645 | |
2459620 | 2459620 | 2022-04-30 | Mayaguez | Puerto Rico | 72097 | 10570 | |
2456364 | 2456364 | 2022-04-29 | Mayaguez | Puerto Rico | 72097 | 10487 | |
2453108 | 2453108 | 2022-04-28 | Mayaguez | Puerto Rico | 72097 | 10372 | |
2449852 | 2449852 | 2022-04-27 | Mayaguez | Puerto Rico | 72097 | 10273 | |
2446595 | 2446595 | 2022-04-26 | Mayaguez | Puerto Rico | 72097 | 10221 | |
2443340 | 2443340 | 2022-04-25 | Mayaguez | Puerto Rico | 72097 | 10213 | |
2440084 | 2440084 | 2022-04-24 | Mayaguez | Puerto Rico | 72097 | 10159 | |
2436828 | 2436828 | 2022-04-23 | Mayaguez | Puerto Rico | 72097 | 10072 | |
2433572 | 2433572 | 2022-04-22 | Mayaguez | Puerto Rico | 72097 | 9997 | |
2430316 | 2430316 | 2022-04-21 | Mayaguez | Puerto Rico | 72097 | 9937 | |
2427060 | 2427060 | 2022-04-20 | Mayaguez | Puerto Rico | 72097 | 9877 | |
2423804 | 2423804 | 2022-04-19 | Mayaguez | Puerto Rico | 72097 | 9846 | |
2420548 | 2420548 | 2022-04-18 | Mayaguez | Puerto Rico | 72097 | 9842 | |
2417292 | 2417292 | 2022-04-17 | Mayaguez | Puerto Rico | 72097 | 9816 | |
2414036 | 2414036 | 2022-04-16 | Mayaguez | Puerto Rico | 72097 | 9758 | |
2410780 | 2410780 | 2022-04-15 | Mayaguez | Puerto Rico | 72097 | 9758 | |
2407524 | 2407524 | 2022-04-14 | Mayaguez | Puerto Rico | 72097 | 9758 | |
2404268 | 2404268 | 2022-04-13 | Mayaguez | Puerto Rico | 72097 | 9733 | |
2401013 | 2401013 | 2022-04-12 | Mayaguez | Puerto Rico | 72097 | 9708 | |
2397758 | 2397758 | 2022-04-11 | Mayaguez | Puerto Rico | 72097 | 9708 | |
2394503 | 2394503 | 2022-04-10 | Mayaguez | Puerto Rico | 72097 | 9695 | |
2391247 | 2391247 | 2022-04-09 | Mayaguez | Puerto Rico | 72097 | 9677 | |
2387991 | 2387991 | 2022-04-08 | Mayaguez | Puerto Rico | 72097 | 9671 | |
2384736 | 2384736 | 2022-04-07 | Mayaguez | Puerto Rico | 72097 | 9653 | |
2381481 | 2381481 | 2022-04-06 | Mayaguez | Puerto Rico | 72097 | 9623 | |
2378226 | 2378226 | 2022-04-05 | Mayaguez | Puerto Rico | 72097 | 9611 | |
2374972 | 2374972 | 2022-04-04 | Mayaguez | Puerto Rico | 72097 | 9611 | |
2371720 | 2371720 | 2022-04-03 | Mayaguez | Puerto Rico | 72097 | 9606 | |
2368467 | 2368467 | 2022-04-02 | Mayaguez | Puerto Rico | 72097 | 9599 | |
2365214 | 2365214 | 2022-04-01 | Mayaguez | Puerto Rico | 72097 | 9592 | |
2361961 | 2361961 | 2022-03-31 | Mayaguez | Puerto Rico | 72097 | 9582 | |
2358707 | 2358707 | 2022-03-30 | Mayaguez | Puerto Rico | 72097 | 9572 | |
2355453 | 2355453 | 2022-03-29 | Mayaguez | Puerto Rico | 72097 | 9567 | |
2352200 | 2352200 | 2022-03-28 | Mayaguez | Puerto Rico | 72097 | 9565 | |
2348948 | 2348948 | 2022-03-27 | Mayaguez | Puerto Rico | 72097 | 9560 | |
2345695 | 2345695 | 2022-03-26 | Mayaguez | Puerto Rico | 72097 | 9557 | |
2342442 | 2342442 | 2022-03-25 | Mayaguez | Puerto Rico | 72097 | 9547 | |
2339189 | 2339189 | 2022-03-24 | Mayaguez | Puerto Rico | 72097 | 9533 | |
2335935 | 2335935 | 2022-03-23 | Mayaguez | Puerto Rico | 72097 | 9521 | |
2332681 | 2332681 | 2022-03-22 | Mayaguez | Puerto Rico | 72097 | 9507 | |
2329428 | 2329428 | 2022-03-21 | Mayaguez | Puerto Rico | 72097 | 9507 | |
2326176 | 2326176 | 2022-03-20 | Mayaguez | Puerto Rico | 72097 | 9505 | |
2322923 | 2322923 | 2022-03-19 | Mayaguez | Puerto Rico | 72097 | 9490 | |
2319669 | 2319669 | 2022-03-18 | Mayaguez | Puerto Rico | 72097 | 9486 | |
2316415 | 2316415 | 2022-03-17 | Mayaguez | Puerto Rico | 72097 | 9479 | |
2313162 | 2313162 | 2022-03-16 | Mayaguez | Puerto Rico | 72097 | 9466 | |
2309909 | 2309909 | 2022-03-15 | Mayaguez | Puerto Rico | 72097 | 9459 | |
2306656 | 2306656 | 2022-03-14 | Mayaguez | Puerto Rico | 72097 | 9456 | |
2303405 | 2303405 | 2022-03-13 | Mayaguez | Puerto Rico | 72097 | 9456 | |
2300153 | 2300153 | 2022-03-12 | Mayaguez | Puerto Rico | 72097 | 9446 | |
2296901 | 2296901 | 2022-03-11 | Mayaguez | Puerto Rico | 72097 | 9445 | |
2293649 | 2293649 | 2022-03-10 | Mayaguez | Puerto Rico | 72097 | 9441 | |
2290397 | 2290397 | 2022-03-09 | Mayaguez | Puerto Rico | 72097 | 9429 | |
2287145 | 2287145 | 2022-03-08 | Mayaguez | Puerto Rico | 72097 | 9423 | |
2283893 | 2283893 | 2022-03-07 | Mayaguez | Puerto Rico | 72097 | 9422 | |
2280641 | 2280641 | 2022-03-06 | Mayaguez | Puerto Rico | 72097 | 9412 | |
2277388 | 2277388 | 2022-03-05 | Mayaguez | Puerto Rico | 72097 | 9411 | |
2274135 | 2274135 | 2022-03-04 | Mayaguez | Puerto Rico | 72097 | 9404 | |
2270882 | 2270882 | 2022-03-03 | Mayaguez | Puerto Rico | 72097 | 9400 | |
2267630 | 2267630 | 2022-03-02 | Mayaguez | Puerto Rico | 72097 | 9392 | |
2264377 | 2264377 | 2022-03-01 | Mayaguez | Puerto Rico | 72097 | 9388 | |
2261127 | 2261127 | 2022-02-28 | Mayaguez | Puerto Rico | 72097 | 9387 | |
2257876 | 2257876 | 2022-02-27 | Mayaguez | Puerto Rico | 72097 | 9383 | |
2254625 | 2254625 | 2022-02-26 | Mayaguez | Puerto Rico | 72097 | 9380 | |
2251374 | 2251374 | 2022-02-25 | Mayaguez | Puerto Rico | 72097 | 9377 | |
2248123 | 2248123 | 2022-02-24 | Mayaguez | Puerto Rico | 72097 | 9377 | |
2244872 | 2244872 | 2022-02-23 | Mayaguez | Puerto Rico | 72097 | 9371 | |
2241621 | 2241621 | 2022-02-22 | Mayaguez | Puerto Rico | 72097 | 9370 | |
2238370 | 2238370 | 2022-02-21 | Mayaguez | Puerto Rico | 72097 | 9370 | |
2235119 | 2235119 | 2022-02-20 | Mayaguez | Puerto Rico | 72097 | 9362 | |
2231868 | 2231868 | 2022-02-19 | Mayaguez | Puerto Rico | 72097 | 9355 | |
2228617 | 2228617 | 2022-02-18 | Mayaguez | Puerto Rico | 72097 | 9339 | |
2225366 | 2225366 | 2022-02-17 | Mayaguez | Puerto Rico | 72097 | 9329 | |
2222115 | 2222115 | 2022-02-16 | Mayaguez | Puerto Rico | 72097 | 9308 | |
2218864 | 2218864 | 2022-02-15 | Mayaguez | Puerto Rico | 72097 | 9288 | |
2215613 | 2215613 | 2022-02-14 | Mayaguez | Puerto Rico | 72097 | 9295 | |
2212362 | 2212362 | 2022-02-13 | Mayaguez | Puerto Rico | 72097 | 9286 | |
2209109 | 2209109 | 2022-02-12 | Mayaguez | Puerto Rico | 72097 | 9275 | |
2205856 | 2205856 | 2022-02-11 | Mayaguez | Puerto Rico | 72097 | 9269 | |
2202603 | 2202603 | 2022-02-10 | Mayaguez | Puerto Rico | 72097 | 9251 | |
2199349 | 2199349 | 2022-02-09 | Mayaguez | Puerto Rico | 72097 | 9220 | |
2196095 | 2196095 | 2022-02-08 | Mayaguez | Puerto Rico | 72097 | 9215 | |
2192841 | 2192841 | 2022-02-07 | Mayaguez | Puerto Rico | 72097 | 9214 | |
2189587 | 2189587 | 2022-02-06 | Mayaguez | Puerto Rico | 72097 | 9209 | |
2186334 | 2186334 | 2022-02-05 | Mayaguez | Puerto Rico | 72097 | 9169 | |
2183082 | 2183082 | 2022-02-04 | Mayaguez | Puerto Rico | 72097 | 9161 | |
2179830 | 2179830 | 2022-02-03 | Mayaguez | Puerto Rico | 72097 | 9122 | |
2176579 | 2176579 | 2022-02-02 | Mayaguez | Puerto Rico | 72097 | 9088 |
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);