ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "El Paso" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280236 | 1280236 | 2021-05-02 | El Paso | Texas | 48141 | 134327 | 2658 |
1276989 | 1276989 | 2021-05-01 | El Paso | Texas | 48141 | 134249 | 2657 |
1273742 | 1273742 | 2021-04-30 | El Paso | Texas | 48141 | 134092 | 2652 |
1270495 | 1270495 | 2021-04-29 | El Paso | Texas | 48141 | 133982 | 2650 |
1267248 | 1267248 | 2021-04-28 | El Paso | Texas | 48141 | 133790 | 2648 |
1264001 | 1264001 | 2021-04-27 | El Paso | Texas | 48141 | 133533 | 2644 |
1260754 | 1260754 | 2021-04-26 | El Paso | Texas | 48141 | 133458 | 2643 |
1257507 | 1257507 | 2021-04-25 | El Paso | Texas | 48141 | 133366 | 2643 |
1254260 | 1254260 | 2021-04-24 | El Paso | Texas | 48141 | 133270 | 2643 |
1251013 | 1251013 | 2021-04-23 | El Paso | Texas | 48141 | 133120 | 2641 |
1247766 | 1247766 | 2021-04-22 | El Paso | Texas | 48141 | 133037 | 2636 |
1244519 | 1244519 | 2021-04-21 | El Paso | Texas | 48141 | 132892 | 2630 |
1241272 | 1241272 | 2021-04-20 | El Paso | Texas | 48141 | 132686 | 2623 |
1238025 | 1238025 | 2021-04-19 | El Paso | Texas | 48141 | 132448 | 2622 |
1234778 | 1234778 | 2021-04-18 | El Paso | Texas | 48141 | 132355 | 2622 |
1231530 | 1231530 | 2021-04-17 | El Paso | Texas | 48141 | 132132 | 2620 |
1228282 | 1228282 | 2021-04-16 | El Paso | Texas | 48141 | 132038 | 2617 |
1225034 | 1225034 | 2021-04-15 | El Paso | Texas | 48141 | 131898 | 2609 |
1221787 | 1221787 | 2021-04-14 | El Paso | Texas | 48141 | 131746 | 2605 |
1218539 | 1218539 | 2021-04-13 | El Paso | Texas | 48141 | 131561 | 2605 |
1215291 | 1215291 | 2021-04-12 | El Paso | Texas | 48141 | 131459 | 2602 |
1212044 | 1212044 | 2021-04-11 | El Paso | Texas | 48141 | 131283 | 2602 |
1208795 | 1208795 | 2021-04-10 | El Paso | Texas | 48141 | 131159 | 2598 |
1205547 | 1205547 | 2021-04-09 | El Paso | Texas | 48141 | 131004 | 2589 |
1202299 | 1202299 | 2021-04-08 | El Paso | Texas | 48141 | 130875 | 2584 |
1199050 | 1199050 | 2021-04-07 | El Paso | Texas | 48141 | 130647 | 2573 |
1195801 | 1195801 | 2021-04-06 | El Paso | Texas | 48141 | 130457 | 2568 |
1192553 | 1192553 | 2021-04-05 | El Paso | Texas | 48141 | 130250 | 2566 |
1189304 | 1189304 | 2021-04-04 | El Paso | Texas | 48141 | 130102 | 2565 |
1186057 | 1186057 | 2021-04-03 | El Paso | Texas | 48141 | 130026 | 2562 |
1182810 | 1182810 | 2021-04-02 | El Paso | Texas | 48141 | 129884 | 2553 |
1179563 | 1179563 | 2021-04-01 | El Paso | Texas | 48141 | 129723 | 2549 |
1176316 | 1176316 | 2021-03-31 | El Paso | Texas | 48141 | 129495 | 2544 |
1173069 | 1173069 | 2021-03-30 | El Paso | Texas | 48141 | 129209 | 2541 |
1169822 | 1169822 | 2021-03-29 | El Paso | Texas | 48141 | 129115 | 2534 |
1166574 | 1166574 | 2021-03-28 | El Paso | Texas | 48141 | 129013 | 2534 |
1163326 | 1163326 | 2021-03-27 | El Paso | Texas | 48141 | 128923 | 2534 |
1160077 | 1160077 | 2021-03-26 | El Paso | Texas | 48141 | 128769 | 2528 |
1156830 | 1156830 | 2021-03-25 | El Paso | Texas | 48141 | 128615 | 2528 |
1153583 | 1153583 | 2021-03-24 | El Paso | Texas | 48141 | 128435 | 2525 |
1150336 | 1150336 | 2021-03-23 | El Paso | Texas | 48141 | 128252 | 2520 |
1147089 | 1147089 | 2021-03-22 | El Paso | Texas | 48141 | 128119 | 2520 |
1143842 | 1143842 | 2021-03-21 | El Paso | Texas | 48141 | 127992 | 2520 |
1140595 | 1140595 | 2021-03-20 | El Paso | Texas | 48141 | 127824 | 2519 |
1137349 | 1137349 | 2021-03-19 | El Paso | Texas | 48141 | 127661 | 2515 |
1134103 | 1134103 | 2021-03-18 | El Paso | Texas | 48141 | 127538 | 2505 |
1130855 | 1130855 | 2021-03-17 | El Paso | Texas | 48141 | 127403 | 2490 |
1127608 | 1127608 | 2021-03-16 | El Paso | Texas | 48141 | 127168 | 2479 |
1124362 | 1124362 | 2021-03-15 | El Paso | Texas | 48141 | 126981 | 2471 |
1121116 | 1121116 | 2021-03-14 | El Paso | Texas | 48141 | 126796 | 2468 |
1117869 | 1117869 | 2021-03-13 | El Paso | Texas | 48141 | 126641 | 2463 |
1114622 | 1114622 | 2021-03-12 | El Paso | Texas | 48141 | 126416 | 2447 |
1111376 | 1111376 | 2021-03-11 | El Paso | Texas | 48141 | 126210 | 2433 |
1108130 | 1108130 | 2021-03-10 | El Paso | Texas | 48141 | 125985 | 2422 |
1104884 | 1104884 | 2021-03-09 | El Paso | Texas | 48141 | 125830 | 2412 |
1101638 | 1101638 | 2021-03-08 | El Paso | Texas | 48141 | 125542 | 2407 |
1098392 | 1098392 | 2021-03-07 | El Paso | Texas | 48141 | 125372 | 2407 |
1095144 | 1095144 | 2021-03-06 | El Paso | Texas | 48141 | 125250 | 2398 |
1091898 | 1091898 | 2021-03-05 | El Paso | Texas | 48141 | 125060 | 2385 |
1088652 | 1088652 | 2021-03-04 | El Paso | Texas | 48141 | 124812 | 2372 |
1085407 | 1085407 | 2021-03-03 | El Paso | Texas | 48141 | 124438 | 2366 |
1082161 | 1082161 | 2021-03-02 | El Paso | Texas | 48141 | 124162 | 2360 |
1078915 | 1078915 | 2021-03-01 | El Paso | Texas | 48141 | 123979 | 2354 |
1075670 | 1075670 | 2021-02-28 | El Paso | Texas | 48141 | 123690 | 2351 |
1072424 | 1072424 | 2021-02-27 | El Paso | Texas | 48141 | 123445 | 2338 |
1069178 | 1069178 | 2021-02-26 | El Paso | Texas | 48141 | 122966 | 2330 |
1065933 | 1065933 | 2021-02-25 | El Paso | Texas | 48141 | 122774 | 2322 |
1062688 | 1062688 | 2021-02-24 | El Paso | Texas | 48141 | 122448 | 2316 |
1059443 | 1059443 | 2021-02-23 | El Paso | Texas | 48141 | 122448 | 2310 |
1056197 | 1056197 | 2021-02-22 | El Paso | Texas | 48141 | 121765 | 2302 |
1052951 | 1052951 | 2021-02-21 | El Paso | Texas | 48141 | 121503 | 2301 |
1049704 | 1049704 | 2021-02-20 | El Paso | Texas | 48141 | 120982 | 2295 |
1046457 | 1046457 | 2021-02-19 | El Paso | Texas | 48141 | 120769 | 2281 |
1043212 | 1043212 | 2021-02-18 | El Paso | Texas | 48141 | 120556 | 2270 |
1039967 | 1039967 | 2021-02-17 | El Paso | Texas | 48141 | 120205 | 2262 |
1036722 | 1036722 | 2021-02-16 | El Paso | Texas | 48141 | 119997 | 2257 |
1033477 | 1033477 | 2021-02-15 | El Paso | Texas | 48141 | 119774 | 2250 |
1030231 | 1030231 | 2021-02-14 | El Paso | Texas | 48141 | 119476 | 2250 |
1026984 | 1026984 | 2021-02-13 | El Paso | Texas | 48141 | 119148 | 2244 |
1023739 | 1023739 | 2021-02-12 | El Paso | Texas | 48141 | 118715 | 2235 |
1020494 | 1020494 | 2021-02-11 | El Paso | Texas | 48141 | 118248 | 2220 |
1017249 | 1017249 | 2021-02-10 | El Paso | Texas | 48141 | 117743 | 2205 |
1014004 | 1014004 | 2021-02-09 | El Paso | Texas | 48141 | 117370 | 2195 |
1010759 | 1010759 | 2021-02-08 | El Paso | Texas | 48141 | 117039 | 2182 |
1007513 | 1007513 | 2021-02-07 | El Paso | Texas | 48141 | 116644 | 2182 |
1004267 | 1004267 | 2021-02-06 | El Paso | Texas | 48141 | 116263 | 2181 |
1001021 | 1001021 | 2021-02-05 | El Paso | Texas | 48141 | 115847 | 2170 |
997775 | 997775 | 2021-02-04 | El Paso | Texas | 48141 | 115300 | 2152 |
994529 | 994529 | 2021-02-03 | El Paso | Texas | 48141 | 114819 | 2142 |
991283 | 991283 | 2021-02-02 | El Paso | Texas | 48141 | 114386 | 2126 |
988037 | 988037 | 2021-02-01 | El Paso | Texas | 48141 | 114058 | 2117 |
984790 | 984790 | 2021-01-31 | El Paso | Texas | 48141 | 113637 | 2116 |
981543 | 981543 | 2021-01-30 | El Paso | Texas | 48141 | 113145 | 2102 |
978297 | 978297 | 2021-01-29 | El Paso | Texas | 48141 | 112652 | 2095 |
975052 | 975052 | 2021-01-28 | El Paso | Texas | 48141 | 112259 | 2086 |
971807 | 971807 | 2021-01-27 | El Paso | Texas | 48141 | 111689 | 2071 |
968562 | 968562 | 2021-01-26 | El Paso | Texas | 48141 | 111061 | 2068 |
965318 | 965318 | 2021-01-25 | El Paso | Texas | 48141 | 111061 | 2064 |
962073 | 962073 | 2021-01-24 | El Paso | Texas | 48141 | 110125 | 2048 |
958828 | 958828 | 2021-01-23 | El Paso | Texas | 48141 | 109589 | 2031 |
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);