ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "El Paso" and state = "Colorado" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
603 | 603 | 2020-03-06 | El Paso | Colorado | 8041 | 1 | 0 |
681 | 681 | 2020-03-07 | El Paso | Colorado | 8041 | 1 | 0 |
776 | 776 | 2020-03-08 | El Paso | Colorado | 8041 | 1 | 0 |
892 | 892 | 2020-03-09 | El Paso | Colorado | 8041 | 1 | 0 |
1026 | 1026 | 2020-03-10 | El Paso | Colorado | 8041 | 1 | 0 |
1193 | 1193 | 2020-03-11 | El Paso | Colorado | 8041 | 1 | 0 |
1401 | 1401 | 2020-03-12 | El Paso | Colorado | 8041 | 1 | 1 |
1663 | 1663 | 2020-03-13 | El Paso | Colorado | 8041 | 2 | 2 |
1982 | 1982 | 2020-03-14 | El Paso | Colorado | 8041 | 3 | 2 |
2363 | 2363 | 2020-03-15 | El Paso | Colorado | 8041 | 4 | 2 |
2798 | 2798 | 2020-03-16 | El Paso | Colorado | 8041 | 6 | 2 |
3280 | 3280 | 2020-03-17 | El Paso | Colorado | 8041 | 6 | 2 |
3834 | 3834 | 2020-03-18 | El Paso | Colorado | 8041 | 8 | 2 |
4495 | 4495 | 2020-03-19 | El Paso | Colorado | 8041 | 15 | 3 |
5271 | 5271 | 2020-03-20 | El Paso | Colorado | 8041 | 27 | 3 |
6195 | 6195 | 2020-03-21 | El Paso | Colorado | 8041 | 37 | 3 |
7230 | 7230 | 2020-03-22 | El Paso | Colorado | 8041 | 51 | 3 |
8373 | 8373 | 2020-03-23 | El Paso | Colorado | 8041 | 69 | 4 |
9616 | 9616 | 2020-03-24 | El Paso | Colorado | 8041 | 106 | 4 |
10989 | 10989 | 2020-03-25 | El Paso | Colorado | 8041 | 122 | 5 |
12534 | 12534 | 2020-03-26 | El Paso | Colorado | 8041 | 137 | 7 |
14202 | 14202 | 2020-03-27 | El Paso | Colorado | 8041 | 160 | 7 |
15985 | 15985 | 2020-03-28 | El Paso | Colorado | 8041 | 184 | 10 |
17875 | 17875 | 2020-03-29 | El Paso | Colorado | 8041 | 214 | 11 |
19853 | 19853 | 2020-03-30 | El Paso | Colorado | 8041 | 245 | 11 |
21928 | 21928 | 2020-03-31 | El Paso | Colorado | 8041 | 286 | 13 |
24087 | 24087 | 2020-04-01 | El Paso | Colorado | 8041 | 314 | 14 |
26317 | 26317 | 2020-04-02 | El Paso | Colorado | 8041 | 340 | 16 |
28617 | 28617 | 2020-04-03 | El Paso | Colorado | 8041 | 374 | 18 |
30974 | 30974 | 2020-04-04 | El Paso | Colorado | 8041 | 406 | 22 |
33380 | 33380 | 2020-04-05 | El Paso | Colorado | 8041 | 435 | 25 |
35825 | 35825 | 2020-04-06 | El Paso | Colorado | 8041 | 441 | 28 |
38315 | 38315 | 2020-04-07 | El Paso | Colorado | 8041 | 457 | 28 |
40858 | 40858 | 2020-04-08 | El Paso | Colorado | 8041 | 472 | 30 |
43430 | 43430 | 2020-04-09 | El Paso | Colorado | 8041 | 534 | 32 |
46030 | 46030 | 2020-04-10 | El Paso | Colorado | 8041 | 550 | 33 |
48660 | 48660 | 2020-04-11 | El Paso | Colorado | 8041 | 578 | 35 |
51322 | 51322 | 2020-04-12 | El Paso | Colorado | 8041 | 613 | 37 |
54001 | 54001 | 2020-04-13 | El Paso | Colorado | 8041 | 641 | 39 |
56693 | 56693 | 2020-04-14 | El Paso | Colorado | 8041 | 652 | 41 |
59401 | 59401 | 2020-04-15 | El Paso | Colorado | 8041 | 668 | 43 |
62120 | 62120 | 2020-04-16 | El Paso | Colorado | 8041 | 689 | 48 |
64853 | 64853 | 2020-04-17 | El Paso | Colorado | 8041 | 708 | 49 |
67601 | 67601 | 2020-04-18 | El Paso | Colorado | 8041 | 721 | 49 |
70363 | 70363 | 2020-04-19 | El Paso | Colorado | 8041 | 731 | 49 |
73132 | 73132 | 2020-04-20 | El Paso | Colorado | 8041 | 734 | 50 |
75908 | 75908 | 2020-04-21 | El Paso | Colorado | 8041 | 744 | 53 |
78692 | 78692 | 2020-04-22 | El Paso | Colorado | 8041 | 774 | 54 |
81486 | 81486 | 2020-04-23 | El Paso | Colorado | 8041 | 798 | 55 |
84286 | 84286 | 2020-04-24 | El Paso | Colorado | 8041 | 853 | 72 |
87094 | 87094 | 2020-04-25 | El Paso | Colorado | 8041 | 862 | 66 |
89911 | 89911 | 2020-04-26 | El Paso | Colorado | 8041 | 867 | 68 |
92729 | 92729 | 2020-04-27 | El Paso | Colorado | 8041 | 879 | 68 |
95561 | 95561 | 2020-04-28 | El Paso | Colorado | 8041 | 884 | 69 |
98406 | 98406 | 2020-04-29 | El Paso | Colorado | 8041 | 907 | 69 |
101256 | 101256 | 2020-04-30 | El Paso | Colorado | 8041 | 934 | 70 |
104111 | 104111 | 2020-05-01 | El Paso | Colorado | 8041 | 964 | 71 |
106976 | 106976 | 2020-05-02 | El Paso | Colorado | 8041 | 988 | 74 |
109845 | 109845 | 2020-05-03 | El Paso | Colorado | 8041 | 994 | 75 |
112720 | 112720 | 2020-05-04 | El Paso | Colorado | 8041 | 1005 | 76 |
115603 | 115603 | 2020-05-05 | El Paso | Colorado | 8041 | 1028 | 78 |
118562 | 118562 | 2020-05-06 | El Paso | Colorado | 8041 | 1055 | 77 |
121531 | 121531 | 2020-05-07 | El Paso | Colorado | 8041 | 1079 | 77 |
124511 | 124511 | 2020-05-08 | El Paso | Colorado | 8041 | 1097 | 78 |
127497 | 127497 | 2020-05-09 | El Paso | Colorado | 8041 | 1109 | 78 |
130488 | 130488 | 2020-05-10 | El Paso | Colorado | 8041 | 1124 | 78 |
133479 | 133479 | 2020-05-11 | El Paso | Colorado | 8041 | 1137 | 79 |
136468 | 136468 | 2020-05-12 | El Paso | Colorado | 8041 | 1157 | 81 |
139459 | 139459 | 2020-05-13 | El Paso | Colorado | 8041 | 1175 | 81 |
142455 | 142455 | 2020-05-14 | El Paso | Colorado | 8041 | 1204 | 81 |
145455 | 145455 | 2020-05-15 | El Paso | Colorado | 8041 | 1251 | 83 |
148458 | 148458 | 2020-05-16 | El Paso | Colorado | 8041 | 1291 | 83 |
151467 | 151467 | 2020-05-17 | El Paso | Colorado | 8041 | 1314 | 83 |
154479 | 154479 | 2020-05-18 | El Paso | Colorado | 8041 | 1348 | 83 |
157495 | 157495 | 2020-05-19 | El Paso | Colorado | 8041 | 1357 | 84 |
160521 | 160521 | 2020-05-20 | El Paso | Colorado | 8041 | 1386 | 88 |
163549 | 163549 | 2020-05-21 | El Paso | Colorado | 8041 | 1428 | 88 |
166582 | 166582 | 2020-05-22 | El Paso | Colorado | 8041 | 1460 | 88 |
169619 | 169619 | 2020-05-23 | El Paso | Colorado | 8041 | 1493 | 88 |
172660 | 172660 | 2020-05-24 | El Paso | Colorado | 8041 | 1505 | 89 |
175704 | 175704 | 2020-05-25 | El Paso | Colorado | 8041 | 1535 | 89 |
178748 | 178748 | 2020-05-26 | El Paso | Colorado | 8041 | 1581 | 89 |
181792 | 181792 | 2020-05-27 | El Paso | Colorado | 8041 | 1600 | 89 |
184846 | 184846 | 2020-05-28 | El Paso | Colorado | 8041 | 1636 | 89 |
187902 | 187902 | 2020-05-29 | El Paso | Colorado | 8041 | 1674 | 89 |
190967 | 190967 | 2020-05-30 | El Paso | Colorado | 8041 | 1717 | 88 |
194034 | 194034 | 2020-05-31 | El Paso | Colorado | 8041 | 1732 | 88 |
197104 | 197104 | 2020-06-01 | El Paso | Colorado | 8041 | 1748 | 89 |
200177 | 200177 | 2020-06-02 | El Paso | Colorado | 8041 | 1761 | 95 |
203253 | 203253 | 2020-06-03 | El Paso | Colorado | 8041 | 1778 | 96 |
206333 | 206333 | 2020-06-04 | El Paso | Colorado | 8041 | 1788 | 96 |
209414 | 209414 | 2020-06-05 | El Paso | Colorado | 8041 | 1802 | 97 |
212499 | 212499 | 2020-06-06 | El Paso | Colorado | 8041 | 1817 | 96 |
215586 | 215586 | 2020-06-07 | El Paso | Colorado | 8041 | 1834 | 96 |
218677 | 218677 | 2020-06-08 | El Paso | Colorado | 8041 | 1862 | 98 |
221772 | 221772 | 2020-06-09 | El Paso | Colorado | 8041 | 1880 | 99 |
224867 | 224867 | 2020-06-10 | El Paso | Colorado | 8041 | 1888 | 100 |
227969 | 227969 | 2020-06-11 | El Paso | Colorado | 8041 | 1907 | 100 |
231072 | 231072 | 2020-06-12 | El Paso | Colorado | 8041 | 1920 | 102 |
234178 | 234178 | 2020-06-13 | El Paso | Colorado | 8041 | 1925 | 102 |
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);