ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48141 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419820 | 1419820 | 2021-06-14 | El Paso | Texas | 48141 | 136343 | 2724 |
1416575 | 1416575 | 2021-06-13 | El Paso | Texas | 48141 | 136338 | 2724 |
1413329 | 1413329 | 2021-06-12 | El Paso | Texas | 48141 | 136334 | 2724 |
1410084 | 1410084 | 2021-06-11 | El Paso | Texas | 48141 | 136319 | 2724 |
1406839 | 1406839 | 2021-06-10 | El Paso | Texas | 48141 | 136303 | 2722 |
1403593 | 1403593 | 2021-06-09 | El Paso | Texas | 48141 | 136267 | 2722 |
1400348 | 1400348 | 2021-06-08 | El Paso | Texas | 48141 | 136257 | 2721 |
1397103 | 1397103 | 2021-06-07 | El Paso | Texas | 48141 | 136251 | 2721 |
1393856 | 1393856 | 2021-06-06 | El Paso | Texas | 48141 | 136233 | 2721 |
1390611 | 1390611 | 2021-06-05 | El Paso | Texas | 48141 | 136208 | 2721 |
1387366 | 1387366 | 2021-06-04 | El Paso | Texas | 48141 | 136196 | 2720 |
1384121 | 1384121 | 2021-06-03 | El Paso | Texas | 48141 | 136182 | 2719 |
1380875 | 1380875 | 2021-06-02 | El Paso | Texas | 48141 | 136154 | 2719 |
1377630 | 1377630 | 2021-06-01 | El Paso | Texas | 48141 | 136132 | 2717 |
1374384 | 1374384 | 2021-05-31 | El Paso | Texas | 48141 | 136106 | 2716 |
1371139 | 1371139 | 2021-05-30 | El Paso | Texas | 48141 | 136086 | 2716 |
1367893 | 1367893 | 2021-05-29 | El Paso | Texas | 48141 | 136045 | 2715 |
1364647 | 1364647 | 2021-05-28 | El Paso | Texas | 48141 | 136028 | 2710 |
1361401 | 1361401 | 2021-05-27 | El Paso | Texas | 48141 | 135974 | 2706 |
1358155 | 1358155 | 2021-05-26 | El Paso | Texas | 48141 | 135951 | 2705 |
1354909 | 1354909 | 2021-05-25 | El Paso | Texas | 48141 | 135927 | 2701 |
1351663 | 1351663 | 2021-05-24 | El Paso | Texas | 48141 | 135883 | 2698 |
1348417 | 1348417 | 2021-05-23 | El Paso | Texas | 48141 | 135880 | 2698 |
1345169 | 1345169 | 2021-05-22 | El Paso | Texas | 48141 | 135843 | 2697 |
1341921 | 1341921 | 2021-05-21 | El Paso | Texas | 48141 | 135804 | 2697 |
1338673 | 1338673 | 2021-05-20 | El Paso | Texas | 48141 | 135758 | 2695 |
1335426 | 1335426 | 2021-05-19 | El Paso | Texas | 48141 | 135699 | 2690 |
1332179 | 1332179 | 2021-05-18 | El Paso | Texas | 48141 | 135570 | 2687 |
1328932 | 1328932 | 2021-05-17 | El Paso | Texas | 48141 | 135448 | 2685 |
1325686 | 1325686 | 2021-05-16 | El Paso | Texas | 48141 | 135389 | 2685 |
1322440 | 1322440 | 2021-05-15 | El Paso | Texas | 48141 | 135317 | 2685 |
1319194 | 1319194 | 2021-05-14 | El Paso | Texas | 48141 | 135278 | 2681 |
1315946 | 1315946 | 2021-05-13 | El Paso | Texas | 48141 | 135229 | 2680 |
1312700 | 1312700 | 2021-05-12 | El Paso | Texas | 48141 | 135186 | 2677 |
1309453 | 1309453 | 2021-05-11 | El Paso | Texas | 48141 | 134925 | 2677 |
1306207 | 1306207 | 2021-05-10 | El Paso | Texas | 48141 | 134860 | 2676 |
1302961 | 1302961 | 2021-05-09 | El Paso | Texas | 48141 | 134825 | 2676 |
1299714 | 1299714 | 2021-05-08 | El Paso | Texas | 48141 | 134752 | 2674 |
1296467 | 1296467 | 2021-05-07 | El Paso | Texas | 48141 | 134591 | 2671 |
1293221 | 1293221 | 2021-05-06 | El Paso | Texas | 48141 | 134488 | 2669 |
1289975 | 1289975 | 2021-05-05 | El Paso | Texas | 48141 | 134488 | 2664 |
1286729 | 1286729 | 2021-05-04 | El Paso | Texas | 48141 | 134441 | 2663 |
1283483 | 1283483 | 2021-05-03 | El Paso | Texas | 48141 | 134392 | 2660 |
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 |
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);