ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8123 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 |
---|---|---|---|---|---|---|---|
1671 | 1671 | 2020-03-13 | Weld | Colorado | 8123 | 1 | 0 |
1991 | 1991 | 2020-03-14 | Weld | Colorado | 8123 | 2 | 0 |
2373 | 2373 | 2020-03-15 | Weld | Colorado | 8123 | 4 | 0 |
2808 | 2808 | 2020-03-16 | Weld | Colorado | 8123 | 4 | 0 |
3290 | 3290 | 2020-03-17 | Weld | Colorado | 8123 | 5 | 1 |
3844 | 3844 | 2020-03-18 | Weld | Colorado | 8123 | 9 | 1 |
4507 | 4507 | 2020-03-19 | Weld | Colorado | 8123 | 9 | 1 |
5285 | 5285 | 2020-03-20 | Weld | Colorado | 8123 | 15 | 1 |
6212 | 6212 | 2020-03-21 | Weld | Colorado | 8123 | 21 | 1 |
7248 | 7248 | 2020-03-22 | Weld | Colorado | 8123 | 37 | 2 |
8394 | 8394 | 2020-03-23 | Weld | Colorado | 8123 | 50 | 2 |
9639 | 9639 | 2020-03-24 | Weld | Colorado | 8123 | 76 | 2 |
11013 | 11013 | 2020-03-25 | Weld | Colorado | 8123 | 87 | 4 |
12561 | 12561 | 2020-03-26 | Weld | Colorado | 8123 | 107 | 4 |
14230 | 14230 | 2020-03-27 | Weld | Colorado | 8123 | 129 | 6 |
16014 | 16014 | 2020-03-28 | Weld | Colorado | 8123 | 161 | 7 |
17906 | 17906 | 2020-03-29 | Weld | Colorado | 8123 | 180 | 9 |
19885 | 19885 | 2020-03-30 | Weld | Colorado | 8123 | 215 | 10 |
21962 | 21962 | 2020-03-31 | Weld | Colorado | 8123 | 255 | 12 |
24121 | 24121 | 2020-04-01 | Weld | Colorado | 8123 | 293 | 13 |
26351 | 26351 | 2020-04-02 | Weld | Colorado | 8123 | 329 | 16 |
28653 | 28653 | 2020-04-03 | Weld | Colorado | 8123 | 379 | 16 |
31011 | 31011 | 2020-04-04 | Weld | Colorado | 8123 | 424 | 22 |
33417 | 33417 | 2020-04-05 | Weld | Colorado | 8123 | 470 | 24 |
35862 | 35862 | 2020-04-06 | Weld | Colorado | 8123 | 504 | 26 |
38352 | 38352 | 2020-04-07 | Weld | Colorado | 8123 | 537 | 27 |
40895 | 40895 | 2020-04-08 | Weld | Colorado | 8123 | 573 | 30 |
43469 | 43469 | 2020-04-09 | Weld | Colorado | 8123 | 614 | 36 |
46069 | 46069 | 2020-04-10 | Weld | Colorado | 8123 | 649 | 40 |
48699 | 48699 | 2020-04-11 | Weld | Colorado | 8123 | 683 | 44 |
51361 | 51361 | 2020-04-12 | Weld | Colorado | 8123 | 738 | 48 |
54040 | 54040 | 2020-04-13 | Weld | Colorado | 8123 | 808 | 53 |
56732 | 56732 | 2020-04-14 | Weld | Colorado | 8123 | 858 | 55 |
59440 | 59440 | 2020-04-15 | Weld | Colorado | 8123 | 928 | 57 |
62159 | 62159 | 2020-04-16 | Weld | Colorado | 8123 | 960 | 60 |
64892 | 64892 | 2020-04-17 | Weld | Colorado | 8123 | 986 | 61 |
67640 | 67640 | 2020-04-18 | Weld | Colorado | 8123 | 1029 | 61 |
70402 | 70402 | 2020-04-19 | Weld | Colorado | 8123 | 1070 | 64 |
73171 | 73171 | 2020-04-20 | Weld | Colorado | 8123 | 1121 | 68 |
75947 | 75947 | 2020-04-21 | Weld | Colorado | 8123 | 1180 | 69 |
78731 | 78731 | 2020-04-22 | Weld | Colorado | 8123 | 1237 | 69 |
81525 | 81525 | 2020-04-23 | Weld | Colorado | 8123 | 1263 | 70 |
84325 | 84325 | 2020-04-24 | Weld | Colorado | 8123 | 1353 | 82 |
87133 | 87133 | 2020-04-25 | Weld | Colorado | 8123 | 1430 | 78 |
89950 | 89950 | 2020-04-26 | Weld | Colorado | 8123 | 1469 | 79 |
92768 | 92768 | 2020-04-27 | Weld | Colorado | 8123 | 1544 | 87 |
95600 | 95600 | 2020-04-28 | Weld | Colorado | 8123 | 1618 | 88 |
98445 | 98445 | 2020-04-29 | Weld | Colorado | 8123 | 1704 | 93 |
101295 | 101295 | 2020-04-30 | Weld | Colorado | 8123 | 1776 | 95 |
104150 | 104150 | 2020-05-01 | Weld | Colorado | 8123 | 1802 | 100 |
107015 | 107015 | 2020-05-02 | Weld | Colorado | 8123 | 1836 | 100 |
109884 | 109884 | 2020-05-03 | Weld | Colorado | 8123 | 1872 | 100 |
112759 | 112759 | 2020-05-04 | Weld | Colorado | 8123 | 1897 | 102 |
115642 | 115642 | 2020-05-05 | Weld | Colorado | 8123 | 1955 | 107 |
118602 | 118602 | 2020-05-06 | Weld | Colorado | 8123 | 1988 | 109 |
121571 | 121571 | 2020-05-07 | Weld | Colorado | 8123 | 2042 | 113 |
124551 | 124551 | 2020-05-08 | Weld | Colorado | 8123 | 2087 | 113 |
127537 | 127537 | 2020-05-09 | Weld | Colorado | 8123 | 2120 | 113 |
130528 | 130528 | 2020-05-10 | Weld | Colorado | 8123 | 2139 | 113 |
133519 | 133519 | 2020-05-11 | Weld | Colorado | 8123 | 2159 | 114 |
136508 | 136508 | 2020-05-12 | Weld | Colorado | 8123 | 2190 | 117 |
139499 | 139499 | 2020-05-13 | Weld | Colorado | 8123 | 2211 | 119 |
142495 | 142495 | 2020-05-14 | Weld | Colorado | 8123 | 2232 | 119 |
145495 | 145495 | 2020-05-15 | Weld | Colorado | 8123 | 2260 | 122 |
148498 | 148498 | 2020-05-16 | Weld | Colorado | 8123 | 2281 | 123 |
151507 | 151507 | 2020-05-17 | Weld | Colorado | 8123 | 2295 | 123 |
154519 | 154519 | 2020-05-18 | Weld | Colorado | 8123 | 2305 | 123 |
157535 | 157535 | 2020-05-19 | Weld | Colorado | 8123 | 2326 | 124 |
160561 | 160561 | 2020-05-20 | Weld | Colorado | 8123 | 2338 | 125 |
163589 | 163589 | 2020-05-21 | Weld | Colorado | 8123 | 2358 | 125 |
166622 | 166622 | 2020-05-22 | Weld | Colorado | 8123 | 2367 | 125 |
169659 | 169659 | 2020-05-23 | Weld | Colorado | 8123 | 2391 | 125 |
172700 | 172700 | 2020-05-24 | Weld | Colorado | 8123 | 2406 | 125 |
175743 | 175743 | 2020-05-25 | Weld | Colorado | 8123 | 2412 | 124 |
178787 | 178787 | 2020-05-26 | Weld | Colorado | 8123 | 2423 | 127 |
181831 | 181831 | 2020-05-27 | Weld | Colorado | 8123 | 2430 | 128 |
184885 | 184885 | 2020-05-28 | Weld | Colorado | 8123 | 2444 | 129 |
187941 | 187941 | 2020-05-29 | Weld | Colorado | 8123 | 2472 | 130 |
191006 | 191006 | 2020-05-30 | Weld | Colorado | 8123 | 2480 | 131 |
194073 | 194073 | 2020-05-31 | Weld | Colorado | 8123 | 2488 | 131 |
197143 | 197143 | 2020-06-01 | Weld | Colorado | 8123 | 2501 | 132 |
200216 | 200216 | 2020-06-02 | Weld | Colorado | 8123 | 2505 | 132 |
203292 | 203292 | 2020-06-03 | Weld | Colorado | 8123 | 2521 | 133 |
206372 | 206372 | 2020-06-04 | Weld | Colorado | 8123 | 2534 | 134 |
209453 | 209453 | 2020-06-05 | Weld | Colorado | 8123 | 2540 | 134 |
212538 | 212538 | 2020-06-06 | Weld | Colorado | 8123 | 2566 | 135 |
215625 | 215625 | 2020-06-07 | Weld | Colorado | 8123 | 2583 | 135 |
218716 | 218716 | 2020-06-08 | Weld | Colorado | 8123 | 2598 | 135 |
221811 | 221811 | 2020-06-09 | Weld | Colorado | 8123 | 2604 | 135 |
224906 | 224906 | 2020-06-10 | Weld | Colorado | 8123 | 2616 | 135 |
228008 | 228008 | 2020-06-11 | Weld | Colorado | 8123 | 2629 | 136 |
231111 | 231111 | 2020-06-12 | Weld | Colorado | 8123 | 2646 | 136 |
234217 | 234217 | 2020-06-13 | Weld | Colorado | 8123 | 2652 | 136 |
237324 | 237324 | 2020-06-14 | Weld | Colorado | 8123 | 2656 | 136 |
240432 | 240432 | 2020-06-15 | Weld | Colorado | 8123 | 2666 | 136 |
243543 | 243543 | 2020-06-16 | Weld | Colorado | 8123 | 2671 | 136 |
246656 | 246656 | 2020-06-17 | Weld | Colorado | 8123 | 2693 | 136 |
249768 | 249768 | 2020-06-18 | Weld | Colorado | 8123 | 2698 | 136 |
252883 | 252883 | 2020-06-19 | Weld | Colorado | 8123 | 2705 | 136 |
256002 | 256002 | 2020-06-20 | Weld | Colorado | 8123 | 2714 | 136 |
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);