ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Matagorda" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280324 | 1280324 | 2021-05-02 | Matagorda | Texas | 48321 | 3961 | 109 |
1277077 | 1277077 | 2021-05-01 | Matagorda | Texas | 48321 | 3961 | 109 |
1273830 | 1273830 | 2021-04-30 | Matagorda | Texas | 48321 | 3943 | 106 |
1270583 | 1270583 | 2021-04-29 | Matagorda | Texas | 48321 | 3930 | 106 |
1267336 | 1267336 | 2021-04-28 | Matagorda | Texas | 48321 | 3880 | 104 |
1264089 | 1264089 | 2021-04-27 | Matagorda | Texas | 48321 | 3871 | 104 |
1260842 | 1260842 | 2021-04-26 | Matagorda | Texas | 48321 | 3867 | 104 |
1257595 | 1257595 | 2021-04-25 | Matagorda | Texas | 48321 | 3860 | 103 |
1254348 | 1254348 | 2021-04-24 | Matagorda | Texas | 48321 | 3840 | 103 |
1251101 | 1251101 | 2021-04-23 | Matagorda | Texas | 48321 | 3838 | 103 |
1247854 | 1247854 | 2021-04-22 | Matagorda | Texas | 48321 | 3826 | 103 |
1244607 | 1244607 | 2021-04-21 | Matagorda | Texas | 48321 | 3803 | 103 |
1241360 | 1241360 | 2021-04-20 | Matagorda | Texas | 48321 | 3779 | 102 |
1238113 | 1238113 | 2021-04-19 | Matagorda | Texas | 48321 | 3768 | 102 |
1234866 | 1234866 | 2021-04-18 | Matagorda | Texas | 48321 | 3760 | 102 |
1231618 | 1231618 | 2021-04-17 | Matagorda | Texas | 48321 | 3747 | 102 |
1228370 | 1228370 | 2021-04-16 | Matagorda | Texas | 48321 | 3742 | 102 |
1225122 | 1225122 | 2021-04-15 | Matagorda | Texas | 48321 | 3731 | 101 |
1221875 | 1221875 | 2021-04-14 | Matagorda | Texas | 48321 | 3707 | 99 |
1218627 | 1218627 | 2021-04-13 | Matagorda | Texas | 48321 | 3677 | 98 |
1215379 | 1215379 | 2021-04-12 | Matagorda | Texas | 48321 | 3667 | 98 |
1212132 | 1212132 | 2021-04-11 | Matagorda | Texas | 48321 | 3658 | 98 |
1208883 | 1208883 | 2021-04-10 | Matagorda | Texas | 48321 | 3646 | 98 |
1205635 | 1205635 | 2021-04-09 | Matagorda | Texas | 48321 | 3631 | 98 |
1202387 | 1202387 | 2021-04-08 | Matagorda | Texas | 48321 | 3615 | 98 |
1199138 | 1199138 | 2021-04-07 | Matagorda | Texas | 48321 | 3605 | 97 |
1195889 | 1195889 | 2021-04-06 | Matagorda | Texas | 48321 | 3580 | 97 |
1192641 | 1192641 | 2021-04-05 | Matagorda | Texas | 48321 | 3528 | 97 |
1189392 | 1189392 | 2021-04-04 | Matagorda | Texas | 48321 | 3514 | 97 |
1186145 | 1186145 | 2021-04-03 | Matagorda | Texas | 48321 | 3489 | 97 |
1182898 | 1182898 | 2021-04-02 | Matagorda | Texas | 48321 | 3477 | 97 |
1179651 | 1179651 | 2021-04-01 | Matagorda | Texas | 48321 | 3458 | 97 |
1176404 | 1176404 | 2021-03-31 | Matagorda | Texas | 48321 | 3445 | 97 |
1173157 | 1173157 | 2021-03-30 | Matagorda | Texas | 48321 | 3423 | 97 |
1169910 | 1169910 | 2021-03-29 | Matagorda | Texas | 48321 | 3417 | 96 |
1166662 | 1166662 | 2021-03-28 | Matagorda | Texas | 48321 | 3401 | 96 |
1163414 | 1163414 | 2021-03-27 | Matagorda | Texas | 48321 | 3393 | 96 |
1160165 | 1160165 | 2021-03-26 | Matagorda | Texas | 48321 | 3374 | 96 |
1156918 | 1156918 | 2021-03-25 | Matagorda | Texas | 48321 | 3363 | 96 |
1153671 | 1153671 | 2021-03-24 | Matagorda | Texas | 48321 | 3358 | 96 |
1150424 | 1150424 | 2021-03-23 | Matagorda | Texas | 48321 | 3354 | 95 |
1147177 | 1147177 | 2021-03-22 | Matagorda | Texas | 48321 | 3343 | 95 |
1143930 | 1143930 | 2021-03-21 | Matagorda | Texas | 48321 | 3339 | 95 |
1140683 | 1140683 | 2021-03-20 | Matagorda | Texas | 48321 | 3328 | 95 |
1137437 | 1137437 | 2021-03-19 | Matagorda | Texas | 48321 | 3314 | 95 |
1134191 | 1134191 | 2021-03-18 | Matagorda | Texas | 48321 | 3305 | 95 |
1130943 | 1130943 | 2021-03-17 | Matagorda | Texas | 48321 | 3295 | 94 |
1127696 | 1127696 | 2021-03-16 | Matagorda | Texas | 48321 | 3285 | 93 |
1124450 | 1124450 | 2021-03-15 | Matagorda | Texas | 48321 | 3283 | 93 |
1121204 | 1121204 | 2021-03-14 | Matagorda | Texas | 48321 | 3278 | 93 |
1117957 | 1117957 | 2021-03-13 | Matagorda | Texas | 48321 | 3268 | 93 |
1114710 | 1114710 | 2021-03-12 | Matagorda | Texas | 48321 | 3259 | 93 |
1111464 | 1111464 | 2021-03-11 | Matagorda | Texas | 48321 | 3244 | 93 |
1108218 | 1108218 | 2021-03-10 | Matagorda | Texas | 48321 | 3230 | 92 |
1104972 | 1104972 | 2021-03-09 | Matagorda | Texas | 48321 | 3221 | 91 |
1101726 | 1101726 | 2021-03-08 | Matagorda | Texas | 48321 | 3213 | 91 |
1098480 | 1098480 | 2021-03-07 | Matagorda | Texas | 48321 | 3212 | 91 |
1095232 | 1095232 | 2021-03-06 | Matagorda | Texas | 48321 | 3204 | 91 |
1091986 | 1091986 | 2021-03-05 | Matagorda | Texas | 48321 | 3201 | 91 |
1088740 | 1088740 | 2021-03-04 | Matagorda | Texas | 48321 | 3194 | 91 |
1085495 | 1085495 | 2021-03-03 | Matagorda | Texas | 48321 | 3183 | 89 |
1082249 | 1082249 | 2021-03-02 | Matagorda | Texas | 48321 | 3171 | 89 |
1079003 | 1079003 | 2021-03-01 | Matagorda | Texas | 48321 | 3168 | 89 |
1075758 | 1075758 | 2021-02-28 | Matagorda | Texas | 48321 | 3162 | 89 |
1072512 | 1072512 | 2021-02-27 | Matagorda | Texas | 48321 | 3155 | 89 |
1069266 | 1069266 | 2021-02-26 | Matagorda | Texas | 48321 | 3147 | 89 |
1066021 | 1066021 | 2021-02-25 | Matagorda | Texas | 48321 | 3139 | 89 |
1062776 | 1062776 | 2021-02-24 | Matagorda | Texas | 48321 | 3124 | 89 |
1059531 | 1059531 | 2021-02-23 | Matagorda | Texas | 48321 | 3118 | 89 |
1056285 | 1056285 | 2021-02-22 | Matagorda | Texas | 48321 | 3110 | 89 |
1053039 | 1053039 | 2021-02-21 | Matagorda | Texas | 48321 | 3107 | 89 |
1049792 | 1049792 | 2021-02-20 | Matagorda | Texas | 48321 | 3096 | 89 |
1046545 | 1046545 | 2021-02-19 | Matagorda | Texas | 48321 | 3090 | 88 |
1043300 | 1043300 | 2021-02-18 | Matagorda | Texas | 48321 | 3083 | 88 |
1040055 | 1040055 | 2021-02-17 | Matagorda | Texas | 48321 | 3068 | 86 |
1036810 | 1036810 | 2021-02-16 | Matagorda | Texas | 48321 | 3064 | 86 |
1033565 | 1033565 | 2021-02-15 | Matagorda | Texas | 48321 | 3046 | 86 |
1030319 | 1030319 | 2021-02-14 | Matagorda | Texas | 48321 | 3028 | 86 |
1027072 | 1027072 | 2021-02-13 | Matagorda | Texas | 48321 | 2994 | 86 |
1023827 | 1023827 | 2021-02-12 | Matagorda | Texas | 48321 | 2971 | 86 |
1020582 | 1020582 | 2021-02-11 | Matagorda | Texas | 48321 | 2957 | 85 |
1017337 | 1017337 | 2021-02-10 | Matagorda | Texas | 48321 | 2939 | 85 |
1014092 | 1014092 | 2021-02-09 | Matagorda | Texas | 48321 | 2919 | 84 |
1010847 | 1010847 | 2021-02-08 | Matagorda | Texas | 48321 | 2913 | 84 |
1007601 | 1007601 | 2021-02-07 | Matagorda | Texas | 48321 | 2901 | 84 |
1004355 | 1004355 | 2021-02-06 | Matagorda | Texas | 48321 | 2889 | 84 |
1001109 | 1001109 | 2021-02-05 | Matagorda | Texas | 48321 | 2871 | 84 |
997863 | 997863 | 2021-02-04 | Matagorda | Texas | 48321 | 2849 | 83 |
994617 | 994617 | 2021-02-03 | Matagorda | Texas | 48321 | 2844 | 82 |
991371 | 991371 | 2021-02-02 | Matagorda | Texas | 48321 | 2814 | 82 |
988125 | 988125 | 2021-02-01 | Matagorda | Texas | 48321 | 2786 | 81 |
984878 | 984878 | 2021-01-31 | Matagorda | Texas | 48321 | 2785 | 81 |
981631 | 981631 | 2021-01-30 | Matagorda | Texas | 48321 | 2760 | 81 |
978385 | 978385 | 2021-01-29 | Matagorda | Texas | 48321 | 2755 | 80 |
975140 | 975140 | 2021-01-28 | Matagorda | Texas | 48321 | 2744 | 80 |
971895 | 971895 | 2021-01-27 | Matagorda | Texas | 48321 | 2708 | 78 |
968650 | 968650 | 2021-01-26 | Matagorda | Texas | 48321 | 2696 | 74 |
965406 | 965406 | 2021-01-25 | Matagorda | Texas | 48321 | 2689 | 73 |
962161 | 962161 | 2021-01-24 | Matagorda | Texas | 48321 | 2677 | 73 |
958916 | 958916 | 2021-01-23 | Matagorda | Texas | 48321 | 2665 | 73 |
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);