ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72045 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 |
---|---|---|---|---|---|---|---|
2501936 | 2501936 | 2022-05-13 | Comerio | Puerto Rico | 72045 | 3361 | |
2498678 | 2498678 | 2022-05-12 | Comerio | Puerto Rico | 72045 | 3327 | |
2495420 | 2495420 | 2022-05-11 | Comerio | Puerto Rico | 72045 | 3288 | |
2492162 | 2492162 | 2022-05-10 | Comerio | Puerto Rico | 72045 | 3255 | |
2488904 | 2488904 | 2022-05-09 | Comerio | Puerto Rico | 72045 | 3253 | |
2485647 | 2485647 | 2022-05-08 | Comerio | Puerto Rico | 72045 | 3205 | |
2482389 | 2482389 | 2022-05-07 | Comerio | Puerto Rico | 72045 | 3205 | |
2479131 | 2479131 | 2022-05-06 | Comerio | Puerto Rico | 72045 | 3178 | |
2475873 | 2475873 | 2022-05-05 | Comerio | Puerto Rico | 72045 | 3163 | |
2472616 | 2472616 | 2022-05-04 | Comerio | Puerto Rico | 72045 | 3117 | |
2469360 | 2469360 | 2022-05-03 | Comerio | Puerto Rico | 72045 | 3102 | |
2466104 | 2466104 | 2022-05-02 | Comerio | Puerto Rico | 72045 | 3097 | |
2462849 | 2462849 | 2022-05-01 | Comerio | Puerto Rico | 72045 | 3088 | |
2459593 | 2459593 | 2022-04-30 | Comerio | Puerto Rico | 72045 | 3060 | |
2456337 | 2456337 | 2022-04-29 | Comerio | Puerto Rico | 72045 | 3040 | |
2453081 | 2453081 | 2022-04-28 | Comerio | Puerto Rico | 72045 | 3004 | |
2449825 | 2449825 | 2022-04-27 | Comerio | Puerto Rico | 72045 | 2976 | |
2446568 | 2446568 | 2022-04-26 | Comerio | Puerto Rico | 72045 | 2951 | |
2443313 | 2443313 | 2022-04-25 | Comerio | Puerto Rico | 72045 | 2947 | |
2440057 | 2440057 | 2022-04-24 | Comerio | Puerto Rico | 72045 | 2940 | |
2436801 | 2436801 | 2022-04-23 | Comerio | Puerto Rico | 72045 | 2914 | |
2433545 | 2433545 | 2022-04-22 | Comerio | Puerto Rico | 72045 | 2894 | |
2430289 | 2430289 | 2022-04-21 | Comerio | Puerto Rico | 72045 | 2869 | |
2427033 | 2427033 | 2022-04-20 | Comerio | Puerto Rico | 72045 | 2850 | |
2423777 | 2423777 | 2022-04-19 | Comerio | Puerto Rico | 72045 | 2840 | |
2420521 | 2420521 | 2022-04-18 | Comerio | Puerto Rico | 72045 | 2837 | |
2417265 | 2417265 | 2022-04-17 | Comerio | Puerto Rico | 72045 | 2834 | |
2414009 | 2414009 | 2022-04-16 | Comerio | Puerto Rico | 72045 | 2810 | |
2410753 | 2410753 | 2022-04-15 | Comerio | Puerto Rico | 72045 | 2810 | |
2407497 | 2407497 | 2022-04-14 | Comerio | Puerto Rico | 72045 | 2810 | |
2404241 | 2404241 | 2022-04-13 | Comerio | Puerto Rico | 72045 | 2805 | |
2400986 | 2400986 | 2022-04-12 | Comerio | Puerto Rico | 72045 | 2802 | |
2397731 | 2397731 | 2022-04-11 | Comerio | Puerto Rico | 72045 | 2802 | |
2394476 | 2394476 | 2022-04-10 | Comerio | Puerto Rico | 72045 | 2800 | |
2391220 | 2391220 | 2022-04-09 | Comerio | Puerto Rico | 72045 | 2796 | |
2387964 | 2387964 | 2022-04-08 | Comerio | Puerto Rico | 72045 | 2793 | |
2384709 | 2384709 | 2022-04-07 | Comerio | Puerto Rico | 72045 | 2790 | |
2381454 | 2381454 | 2022-04-06 | Comerio | Puerto Rico | 72045 | 2785 | |
2378199 | 2378199 | 2022-04-05 | Comerio | Puerto Rico | 72045 | 2779 | |
2374945 | 2374945 | 2022-04-04 | Comerio | Puerto Rico | 72045 | 2778 | |
2371693 | 2371693 | 2022-04-03 | Comerio | Puerto Rico | 72045 | 2774 | |
2368440 | 2368440 | 2022-04-02 | Comerio | Puerto Rico | 72045 | 2772 | |
2365187 | 2365187 | 2022-04-01 | Comerio | Puerto Rico | 72045 | 2771 | |
2361934 | 2361934 | 2022-03-31 | Comerio | Puerto Rico | 72045 | 2766 | |
2358680 | 2358680 | 2022-03-30 | Comerio | Puerto Rico | 72045 | 2763 | |
2355426 | 2355426 | 2022-03-29 | Comerio | Puerto Rico | 72045 | 2762 | |
2352173 | 2352173 | 2022-03-28 | Comerio | Puerto Rico | 72045 | 2762 | |
2348921 | 2348921 | 2022-03-27 | Comerio | Puerto Rico | 72045 | 2762 | |
2345668 | 2345668 | 2022-03-26 | Comerio | Puerto Rico | 72045 | 2762 | |
2342415 | 2342415 | 2022-03-25 | Comerio | Puerto Rico | 72045 | 2757 | |
2339162 | 2339162 | 2022-03-24 | Comerio | Puerto Rico | 72045 | 2757 | |
2335908 | 2335908 | 2022-03-23 | Comerio | Puerto Rico | 72045 | 2756 | |
2332654 | 2332654 | 2022-03-22 | Comerio | Puerto Rico | 72045 | 2754 | |
2329401 | 2329401 | 2022-03-21 | Comerio | Puerto Rico | 72045 | 2754 | |
2326149 | 2326149 | 2022-03-20 | Comerio | Puerto Rico | 72045 | 2753 | |
2322896 | 2322896 | 2022-03-19 | Comerio | Puerto Rico | 72045 | 2748 | |
2319642 | 2319642 | 2022-03-18 | Comerio | Puerto Rico | 72045 | 2746 | |
2316388 | 2316388 | 2022-03-17 | Comerio | Puerto Rico | 72045 | 2746 | |
2313135 | 2313135 | 2022-03-16 | Comerio | Puerto Rico | 72045 | 2746 | |
2309882 | 2309882 | 2022-03-15 | Comerio | Puerto Rico | 72045 | 2746 | |
2306629 | 2306629 | 2022-03-14 | Comerio | Puerto Rico | 72045 | 2746 | |
2303378 | 2303378 | 2022-03-13 | Comerio | Puerto Rico | 72045 | 2746 | |
2300126 | 2300126 | 2022-03-12 | Comerio | Puerto Rico | 72045 | 2743 | |
2296874 | 2296874 | 2022-03-11 | Comerio | Puerto Rico | 72045 | 2743 | |
2293622 | 2293622 | 2022-03-10 | Comerio | Puerto Rico | 72045 | 2742 | |
2290370 | 2290370 | 2022-03-09 | Comerio | Puerto Rico | 72045 | 2741 | |
2287118 | 2287118 | 2022-03-08 | Comerio | Puerto Rico | 72045 | 2740 | |
2283866 | 2283866 | 2022-03-07 | Comerio | Puerto Rico | 72045 | 2740 | |
2280614 | 2280614 | 2022-03-06 | Comerio | Puerto Rico | 72045 | 2741 | |
2277361 | 2277361 | 2022-03-05 | Comerio | Puerto Rico | 72045 | 2741 | |
2274108 | 2274108 | 2022-03-04 | Comerio | Puerto Rico | 72045 | 2739 | |
2270855 | 2270855 | 2022-03-03 | Comerio | Puerto Rico | 72045 | 2739 | |
2267603 | 2267603 | 2022-03-02 | Comerio | Puerto Rico | 72045 | 2739 | |
2264350 | 2264350 | 2022-03-01 | Comerio | Puerto Rico | 72045 | 2738 | |
2261100 | 2261100 | 2022-02-28 | Comerio | Puerto Rico | 72045 | 2738 | |
2257849 | 2257849 | 2022-02-27 | Comerio | Puerto Rico | 72045 | 2736 | |
2254598 | 2254598 | 2022-02-26 | Comerio | Puerto Rico | 72045 | 2733 | |
2251347 | 2251347 | 2022-02-25 | Comerio | Puerto Rico | 72045 | 2731 | |
2248096 | 2248096 | 2022-02-24 | Comerio | Puerto Rico | 72045 | 2731 | |
2244845 | 2244845 | 2022-02-23 | Comerio | Puerto Rico | 72045 | 2729 | |
2241594 | 2241594 | 2022-02-22 | Comerio | Puerto Rico | 72045 | 2729 | |
2238343 | 2238343 | 2022-02-21 | Comerio | Puerto Rico | 72045 | 2729 | |
2235092 | 2235092 | 2022-02-20 | Comerio | Puerto Rico | 72045 | 2729 | |
2231841 | 2231841 | 2022-02-19 | Comerio | Puerto Rico | 72045 | 2723 | |
2228590 | 2228590 | 2022-02-18 | Comerio | Puerto Rico | 72045 | 2722 | |
2225339 | 2225339 | 2022-02-17 | Comerio | Puerto Rico | 72045 | 2721 | |
2222088 | 2222088 | 2022-02-16 | Comerio | Puerto Rico | 72045 | 2720 | |
2218837 | 2218837 | 2022-02-15 | Comerio | Puerto Rico | 72045 | 2720 | |
2215586 | 2215586 | 2022-02-14 | Comerio | Puerto Rico | 72045 | 2720 | |
2212335 | 2212335 | 2022-02-13 | Comerio | Puerto Rico | 72045 | 2720 | |
2209082 | 2209082 | 2022-02-12 | Comerio | Puerto Rico | 72045 | 2718 | |
2205829 | 2205829 | 2022-02-11 | Comerio | Puerto Rico | 72045 | 2717 | |
2202576 | 2202576 | 2022-02-10 | Comerio | Puerto Rico | 72045 | 2711 | |
2199322 | 2199322 | 2022-02-09 | Comerio | Puerto Rico | 72045 | 2706 | |
2196068 | 2196068 | 2022-02-08 | Comerio | Puerto Rico | 72045 | 2704 | |
2192814 | 2192814 | 2022-02-07 | Comerio | Puerto Rico | 72045 | 2704 | |
2189560 | 2189560 | 2022-02-06 | Comerio | Puerto Rico | 72045 | 2704 | |
2186307 | 2186307 | 2022-02-05 | Comerio | Puerto Rico | 72045 | 2694 | |
2183055 | 2183055 | 2022-02-04 | Comerio | Puerto Rico | 72045 | 2688 | |
2179803 | 2179803 | 2022-02-03 | Comerio | Puerto Rico | 72045 | 2682 |
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);