ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Arecibo" 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 |
---|---|---|---|---|---|---|---|
1195445 | 1195445 | 2021-04-06 | Arecibo | Puerto Rico | 72013 | 3056 | |
1192197 | 1192197 | 2021-04-05 | Arecibo | Puerto Rico | 72013 | 3056 | |
1188948 | 1188948 | 2021-04-04 | Arecibo | Puerto Rico | 72013 | 3055 | |
1185701 | 1185701 | 2021-04-03 | Arecibo | Puerto Rico | 72013 | 3044 | |
1182454 | 1182454 | 2021-04-02 | Arecibo | Puerto Rico | 72013 | 3032 | |
1179207 | 1179207 | 2021-04-01 | Arecibo | Puerto Rico | 72013 | 3029 | |
1175960 | 1175960 | 2021-03-31 | Arecibo | Puerto Rico | 72013 | 3020 | |
1172713 | 1172713 | 2021-03-30 | Arecibo | Puerto Rico | 72013 | 3020 | |
1169466 | 1169466 | 2021-03-29 | Arecibo | Puerto Rico | 72013 | 3012 | |
1166218 | 1166218 | 2021-03-28 | Arecibo | Puerto Rico | 72013 | 3006 | |
1162970 | 1162970 | 2021-03-27 | Arecibo | Puerto Rico | 72013 | 2997 | |
1159721 | 1159721 | 2021-03-26 | Arecibo | Puerto Rico | 72013 | 2990 | |
1156474 | 1156474 | 2021-03-25 | Arecibo | Puerto Rico | 72013 | 2985 | |
1153227 | 1153227 | 2021-03-24 | Arecibo | Puerto Rico | 72013 | 2983 | |
1149980 | 1149980 | 2021-03-23 | Arecibo | Puerto Rico | 72013 | 2982 | |
1146733 | 1146733 | 2021-03-22 | Arecibo | Puerto Rico | 72013 | 2979 | |
1143486 | 1143486 | 2021-03-21 | Arecibo | Puerto Rico | 72013 | 2972 | |
1140239 | 1140239 | 2021-03-20 | Arecibo | Puerto Rico | 72013 | 2963 | |
1136993 | 1136993 | 2021-03-19 | Arecibo | Puerto Rico | 72013 | 2961 | |
1133747 | 1133747 | 2021-03-18 | Arecibo | Puerto Rico | 72013 | 2957 | |
1130499 | 1130499 | 2021-03-17 | Arecibo | Puerto Rico | 72013 | 2956 | |
1127252 | 1127252 | 2021-03-16 | Arecibo | Puerto Rico | 72013 | 2955 | |
1124006 | 1124006 | 2021-03-15 | Arecibo | Puerto Rico | 72013 | 2952 | |
1120760 | 1120760 | 2021-03-14 | Arecibo | Puerto Rico | 72013 | 2946 | |
1117513 | 1117513 | 2021-03-13 | Arecibo | Puerto Rico | 72013 | 2941 | |
1114266 | 1114266 | 2021-03-12 | Arecibo | Puerto Rico | 72013 | 2937 | |
1111020 | 1111020 | 2021-03-11 | Arecibo | Puerto Rico | 72013 | 2934 | |
1107774 | 1107774 | 2021-03-10 | Arecibo | Puerto Rico | 72013 | 2931 | |
1104528 | 1104528 | 2021-03-09 | Arecibo | Puerto Rico | 72013 | 2931 | |
1101282 | 1101282 | 2021-03-08 | Arecibo | Puerto Rico | 72013 | 2926 | |
1098036 | 1098036 | 2021-03-07 | Arecibo | Puerto Rico | 72013 | 2916 | |
1094788 | 1094788 | 2021-03-06 | Arecibo | Puerto Rico | 72013 | 2916 | |
1091542 | 1091542 | 2021-03-05 | Arecibo | Puerto Rico | 72013 | 2904 | |
1088296 | 1088296 | 2021-03-04 | Arecibo | Puerto Rico | 72013 | 2897 | |
1085051 | 1085051 | 2021-03-03 | Arecibo | Puerto Rico | 72013 | 2896 | |
1081805 | 1081805 | 2021-03-02 | Arecibo | Puerto Rico | 72013 | 2894 | |
1078559 | 1078559 | 2021-03-01 | Arecibo | Puerto Rico | 72013 | 2893 | |
1075314 | 1075314 | 2021-02-28 | Arecibo | Puerto Rico | 72013 | 2879 | |
1072068 | 1072068 | 2021-02-27 | Arecibo | Puerto Rico | 72013 | 2868 | |
1068822 | 1068822 | 2021-02-26 | Arecibo | Puerto Rico | 72013 | 2854 | |
1065577 | 1065577 | 2021-02-25 | Arecibo | Puerto Rico | 72013 | 2844 | |
1062332 | 1062332 | 2021-02-24 | Arecibo | Puerto Rico | 72013 | 2844 | |
1059087 | 1059087 | 2021-02-23 | Arecibo | Puerto Rico | 72013 | 2842 | |
1055841 | 1055841 | 2021-02-22 | Arecibo | Puerto Rico | 72013 | 2834 | |
1052595 | 1052595 | 2021-02-21 | Arecibo | Puerto Rico | 72013 | 2831 | |
1049348 | 1049348 | 2021-02-20 | Arecibo | Puerto Rico | 72013 | 2828 | |
1046101 | 1046101 | 2021-02-19 | Arecibo | Puerto Rico | 72013 | 2823 | |
1042856 | 1042856 | 2021-02-18 | Arecibo | Puerto Rico | 72013 | 2820 | |
1039611 | 1039611 | 2021-02-17 | Arecibo | Puerto Rico | 72013 | 2817 | |
1036366 | 1036366 | 2021-02-16 | Arecibo | Puerto Rico | 72013 | 2809 | |
1033121 | 1033121 | 2021-02-15 | Arecibo | Puerto Rico | 72013 | 2799 | |
1029875 | 1029875 | 2021-02-14 | Arecibo | Puerto Rico | 72013 | 2790 | |
1026628 | 1026628 | 2021-02-13 | Arecibo | Puerto Rico | 72013 | 2786 | |
1023383 | 1023383 | 2021-02-12 | Arecibo | Puerto Rico | 72013 | 2774 | |
1020138 | 1020138 | 2021-02-11 | Arecibo | Puerto Rico | 72013 | 2768 | |
1016893 | 1016893 | 2021-02-10 | Arecibo | Puerto Rico | 72013 | 2765 | |
1013648 | 1013648 | 2021-02-09 | Arecibo | Puerto Rico | 72013 | 2764 | |
1010403 | 1010403 | 2021-02-08 | Arecibo | Puerto Rico | 72013 | 2759 | |
1007157 | 1007157 | 2021-02-07 | Arecibo | Puerto Rico | 72013 | 2753 | |
1003911 | 1003911 | 2021-02-06 | Arecibo | Puerto Rico | 72013 | 2740 | |
1000665 | 1000665 | 2021-02-05 | Arecibo | Puerto Rico | 72013 | 2732 | |
997419 | 997419 | 2021-02-04 | Arecibo | Puerto Rico | 72013 | 2732 | |
994173 | 994173 | 2021-02-03 | Arecibo | Puerto Rico | 72013 | 2718 | |
990927 | 990927 | 2021-02-02 | Arecibo | Puerto Rico | 72013 | 2717 | |
987681 | 987681 | 2021-02-01 | Arecibo | Puerto Rico | 72013 | 2707 | |
984434 | 984434 | 2021-01-31 | Arecibo | Puerto Rico | 72013 | 2695 | |
981187 | 981187 | 2021-01-30 | Arecibo | Puerto Rico | 72013 | 2692 | |
977941 | 977941 | 2021-01-29 | Arecibo | Puerto Rico | 72013 | 2684 | |
974696 | 974696 | 2021-01-28 | Arecibo | Puerto Rico | 72013 | 2675 | |
971451 | 971451 | 2021-01-27 | Arecibo | Puerto Rico | 72013 | 2671 | |
968206 | 968206 | 2021-01-26 | Arecibo | Puerto Rico | 72013 | 2670 | |
964962 | 964962 | 2021-01-25 | Arecibo | Puerto Rico | 72013 | 2658 | |
961717 | 961717 | 2021-01-24 | Arecibo | Puerto Rico | 72013 | 2651 | |
958472 | 958472 | 2021-01-23 | Arecibo | Puerto Rico | 72013 | 2634 | |
955226 | 955226 | 2021-01-22 | Arecibo | Puerto Rico | 72013 | 2620 | |
951981 | 951981 | 2021-01-21 | Arecibo | Puerto Rico | 72013 | 2614 | |
948736 | 948736 | 2021-01-20 | Arecibo | Puerto Rico | 72013 | 2610 | |
945490 | 945490 | 2021-01-19 | Arecibo | Puerto Rico | 72013 | 2610 | |
942243 | 942243 | 2021-01-18 | Arecibo | Puerto Rico | 72013 | 2598 | |
938998 | 938998 | 2021-01-17 | Arecibo | Puerto Rico | 72013 | 2589 | |
935753 | 935753 | 2021-01-16 | Arecibo | Puerto Rico | 72013 | 2577 | |
932508 | 932508 | 2021-01-15 | Arecibo | Puerto Rico | 72013 | 2562 | |
929263 | 929263 | 2021-01-14 | Arecibo | Puerto Rico | 72013 | 2530 | |
926018 | 926018 | 2021-01-13 | Arecibo | Puerto Rico | 72013 | 2528 | |
922772 | 922772 | 2021-01-12 | Arecibo | Puerto Rico | 72013 | 2525 | |
919527 | 919527 | 2021-01-11 | Arecibo | Puerto Rico | 72013 | 2499 | |
916282 | 916282 | 2021-01-10 | Arecibo | Puerto Rico | 72013 | 2495 | |
913037 | 913037 | 2021-01-09 | Arecibo | Puerto Rico | 72013 | 2483 | |
909792 | 909792 | 2021-01-08 | Arecibo | Puerto Rico | 72013 | 2461 | |
906547 | 906547 | 2021-01-07 | Arecibo | Puerto Rico | 72013 | 2415 | |
903301 | 903301 | 2021-01-06 | Arecibo | Puerto Rico | 72013 | 2402 | |
900056 | 900056 | 2021-01-05 | Arecibo | Puerto Rico | 72013 | 2392 | |
896811 | 896811 | 2021-01-04 | Arecibo | Puerto Rico | 72013 | 2390 | |
893565 | 893565 | 2021-01-03 | Arecibo | Puerto Rico | 72013 | 2372 | |
890319 | 890319 | 2021-01-02 | Arecibo | Puerto Rico | 72013 | 2369 | |
887072 | 887072 | 2021-01-01 | Arecibo | Puerto Rico | 72013 | 2348 | |
883827 | 883827 | 2020-12-31 | Arecibo | Puerto Rico | 72013 | 2321 | |
880582 | 880582 | 2020-12-30 | Arecibo | Puerto Rico | 72013 | 2314 | |
877337 | 877337 | 2020-12-29 | Arecibo | Puerto Rico | 72013 | 2314 | |
874092 | 874092 | 2020-12-28 | Arecibo | Puerto Rico | 72013 | 2281 |
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);