ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 48203 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419852 | 1419852 | 2021-06-14 | Harrison | Texas | 48203 | 4938 | 110 |
1416607 | 1416607 | 2021-06-13 | Harrison | Texas | 48203 | 4935 | 110 |
1413361 | 1413361 | 2021-06-12 | Harrison | Texas | 48203 | 4935 | 110 |
1410116 | 1410116 | 2021-06-11 | Harrison | Texas | 48203 | 4934 | 110 |
1406871 | 1406871 | 2021-06-10 | Harrison | Texas | 48203 | 4935 | 110 |
1403625 | 1403625 | 2021-06-09 | Harrison | Texas | 48203 | 4932 | 110 |
1400380 | 1400380 | 2021-06-08 | Harrison | Texas | 48203 | 4932 | 110 |
1397135 | 1397135 | 2021-06-07 | Harrison | Texas | 48203 | 4930 | 110 |
1393888 | 1393888 | 2021-06-06 | Harrison | Texas | 48203 | 4930 | 110 |
1390643 | 1390643 | 2021-06-05 | Harrison | Texas | 48203 | 4928 | 110 |
1387398 | 1387398 | 2021-06-04 | Harrison | Texas | 48203 | 4930 | 110 |
1384153 | 1384153 | 2021-06-03 | Harrison | Texas | 48203 | 4928 | 110 |
1380907 | 1380907 | 2021-06-02 | Harrison | Texas | 48203 | 4926 | 110 |
1377662 | 1377662 | 2021-06-01 | Harrison | Texas | 48203 | 4922 | 109 |
1374416 | 1374416 | 2021-05-31 | Harrison | Texas | 48203 | 4922 | 109 |
1371171 | 1371171 | 2021-05-30 | Harrison | Texas | 48203 | 4921 | 109 |
1367925 | 1367925 | 2021-05-29 | Harrison | Texas | 48203 | 4918 | 109 |
1364679 | 1364679 | 2021-05-28 | Harrison | Texas | 48203 | 4918 | 109 |
1361433 | 1361433 | 2021-05-27 | Harrison | Texas | 48203 | 4913 | 109 |
1358187 | 1358187 | 2021-05-26 | Harrison | Texas | 48203 | 4908 | 109 |
1354941 | 1354941 | 2021-05-25 | Harrison | Texas | 48203 | 4908 | 109 |
1351695 | 1351695 | 2021-05-24 | Harrison | Texas | 48203 | 4905 | 109 |
1348449 | 1348449 | 2021-05-23 | Harrison | Texas | 48203 | 4900 | 109 |
1345201 | 1345201 | 2021-05-22 | Harrison | Texas | 48203 | 4898 | 109 |
1341953 | 1341953 | 2021-05-21 | Harrison | Texas | 48203 | 4897 | 109 |
1338705 | 1338705 | 2021-05-20 | Harrison | Texas | 48203 | 4897 | 109 |
1335458 | 1335458 | 2021-05-19 | Harrison | Texas | 48203 | 4895 | 109 |
1332211 | 1332211 | 2021-05-18 | Harrison | Texas | 48203 | 4894 | 109 |
1328964 | 1328964 | 2021-05-17 | Harrison | Texas | 48203 | 4887 | 109 |
1325718 | 1325718 | 2021-05-16 | Harrison | Texas | 48203 | 4885 | 109 |
1322472 | 1322472 | 2021-05-15 | Harrison | Texas | 48203 | 4881 | 109 |
1319226 | 1319226 | 2021-05-14 | Harrison | Texas | 48203 | 4875 | 109 |
1315978 | 1315978 | 2021-05-13 | Harrison | Texas | 48203 | 4873 | 109 |
1312732 | 1312732 | 2021-05-12 | Harrison | Texas | 48203 | 4869 | 109 |
1309485 | 1309485 | 2021-05-11 | Harrison | Texas | 48203 | 4863 | 109 |
1306239 | 1306239 | 2021-05-10 | Harrison | Texas | 48203 | 4858 | 109 |
1302993 | 1302993 | 2021-05-09 | Harrison | Texas | 48203 | 4856 | 109 |
1299746 | 1299746 | 2021-05-08 | Harrison | Texas | 48203 | 4851 | 109 |
1296499 | 1296499 | 2021-05-07 | Harrison | Texas | 48203 | 4842 | 109 |
1293253 | 1293253 | 2021-05-06 | Harrison | Texas | 48203 | 4834 | 109 |
1290007 | 1290007 | 2021-05-05 | Harrison | Texas | 48203 | 4829 | 108 |
1286761 | 1286761 | 2021-05-04 | Harrison | Texas | 48203 | 4825 | 108 |
1283515 | 1283515 | 2021-05-03 | Harrison | Texas | 48203 | 4815 | 107 |
1280268 | 1280268 | 2021-05-02 | Harrison | Texas | 48203 | 4815 | 107 |
1277021 | 1277021 | 2021-05-01 | Harrison | Texas | 48203 | 4815 | 107 |
1273774 | 1273774 | 2021-04-30 | Harrison | Texas | 48203 | 4811 | 107 |
1270527 | 1270527 | 2021-04-29 | Harrison | Texas | 48203 | 4807 | 107 |
1267280 | 1267280 | 2021-04-28 | Harrison | Texas | 48203 | 4805 | 106 |
1264033 | 1264033 | 2021-04-27 | Harrison | Texas | 48203 | 4794 | 106 |
1260786 | 1260786 | 2021-04-26 | Harrison | Texas | 48203 | 4788 | 106 |
1257539 | 1257539 | 2021-04-25 | Harrison | Texas | 48203 | 4785 | 106 |
1254292 | 1254292 | 2021-04-24 | Harrison | Texas | 48203 | 4785 | 106 |
1251045 | 1251045 | 2021-04-23 | Harrison | Texas | 48203 | 4778 | 106 |
1247798 | 1247798 | 2021-04-22 | Harrison | Texas | 48203 | 4774 | 106 |
1244551 | 1244551 | 2021-04-21 | Harrison | Texas | 48203 | 4772 | 105 |
1241304 | 1241304 | 2021-04-20 | Harrison | Texas | 48203 | 4762 | 105 |
1238057 | 1238057 | 2021-04-19 | Harrison | Texas | 48203 | 4756 | 105 |
1234810 | 1234810 | 2021-04-18 | Harrison | Texas | 48203 | 4756 | 105 |
1231562 | 1231562 | 2021-04-17 | Harrison | Texas | 48203 | 4755 | 105 |
1228314 | 1228314 | 2021-04-16 | Harrison | Texas | 48203 | 4749 | 105 |
1225066 | 1225066 | 2021-04-15 | Harrison | Texas | 48203 | 4749 | 105 |
1221819 | 1221819 | 2021-04-14 | Harrison | Texas | 48203 | 4743 | 105 |
1218571 | 1218571 | 2021-04-13 | Harrison | Texas | 48203 | 4733 | 105 |
1215323 | 1215323 | 2021-04-12 | Harrison | Texas | 48203 | 4729 | 105 |
1212076 | 1212076 | 2021-04-11 | Harrison | Texas | 48203 | 4729 | 105 |
1208827 | 1208827 | 2021-04-10 | Harrison | Texas | 48203 | 4724 | 105 |
1205579 | 1205579 | 2021-04-09 | Harrison | Texas | 48203 | 4722 | 105 |
1202331 | 1202331 | 2021-04-08 | Harrison | Texas | 48203 | 4715 | 105 |
1199082 | 1199082 | 2021-04-07 | Harrison | Texas | 48203 | 4711 | 105 |
1195833 | 1195833 | 2021-04-06 | Harrison | Texas | 48203 | 4703 | 105 |
1192585 | 1192585 | 2021-04-05 | Harrison | Texas | 48203 | 4696 | 105 |
1189336 | 1189336 | 2021-04-04 | Harrison | Texas | 48203 | 4696 | 105 |
1186089 | 1186089 | 2021-04-03 | Harrison | Texas | 48203 | 4694 | 105 |
1182842 | 1182842 | 2021-04-02 | Harrison | Texas | 48203 | 4690 | 105 |
1179595 | 1179595 | 2021-04-01 | Harrison | Texas | 48203 | 4687 | 105 |
1176348 | 1176348 | 2021-03-31 | Harrison | Texas | 48203 | 4666 | 104 |
1173101 | 1173101 | 2021-03-30 | Harrison | Texas | 48203 | 4666 | 104 |
1169854 | 1169854 | 2021-03-29 | Harrison | Texas | 48203 | 4666 | 104 |
1166606 | 1166606 | 2021-03-28 | Harrison | Texas | 48203 | 4666 | 104 |
1163358 | 1163358 | 2021-03-27 | Harrison | Texas | 48203 | 4665 | 104 |
1160109 | 1160109 | 2021-03-26 | Harrison | Texas | 48203 | 4659 | 104 |
1156862 | 1156862 | 2021-03-25 | Harrison | Texas | 48203 | 4655 | 104 |
1153615 | 1153615 | 2021-03-24 | Harrison | Texas | 48203 | 4648 | 102 |
1150368 | 1150368 | 2021-03-23 | Harrison | Texas | 48203 | 4641 | 102 |
1147121 | 1147121 | 2021-03-22 | Harrison | Texas | 48203 | 4634 | 102 |
1143874 | 1143874 | 2021-03-21 | Harrison | Texas | 48203 | 4632 | 102 |
1140627 | 1140627 | 2021-03-20 | Harrison | Texas | 48203 | 4628 | 102 |
1137381 | 1137381 | 2021-03-19 | Harrison | Texas | 48203 | 4622 | 101 |
1134135 | 1134135 | 2021-03-18 | Harrison | Texas | 48203 | 4619 | 101 |
1130887 | 1130887 | 2021-03-17 | Harrison | Texas | 48203 | 4613 | 101 |
1127640 | 1127640 | 2021-03-16 | Harrison | Texas | 48203 | 4609 | 100 |
1124394 | 1124394 | 2021-03-15 | Harrison | Texas | 48203 | 4605 | 100 |
1121148 | 1121148 | 2021-03-14 | Harrison | Texas | 48203 | 4603 | 100 |
1117901 | 1117901 | 2021-03-13 | Harrison | Texas | 48203 | 4602 | 99 |
1114654 | 1114654 | 2021-03-12 | Harrison | Texas | 48203 | 4597 | 99 |
1111408 | 1111408 | 2021-03-11 | Harrison | Texas | 48203 | 4595 | 98 |
1108162 | 1108162 | 2021-03-10 | Harrison | Texas | 48203 | 4592 | 98 |
1104916 | 1104916 | 2021-03-09 | Harrison | Texas | 48203 | 4588 | 95 |
1101670 | 1101670 | 2021-03-08 | Harrison | Texas | 48203 | 4587 | 95 |
1098424 | 1098424 | 2021-03-07 | Harrison | Texas | 48203 | 4581 | 95 |
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);