ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Dallas" and fips = 19049 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 |
---|---|---|---|---|---|---|---|
2060 | 2060 | 2020-03-14 | Dallas | Iowa | 19049 | 1 | 0 |
2455 | 2455 | 2020-03-15 | Dallas | Iowa | 19049 | 1 | 0 |
2900 | 2900 | 2020-03-16 | Dallas | Iowa | 19049 | 1 | 0 |
3393 | 3393 | 2020-03-17 | Dallas | Iowa | 19049 | 3 | 0 |
3967 | 3967 | 2020-03-18 | Dallas | Iowa | 19049 | 5 | 0 |
4646 | 4646 | 2020-03-19 | Dallas | Iowa | 19049 | 5 | 0 |
5457 | 5457 | 2020-03-20 | Dallas | Iowa | 19049 | 5 | 0 |
6398 | 6398 | 2020-03-21 | Dallas | Iowa | 19049 | 5 | 0 |
7459 | 7459 | 2020-03-22 | Dallas | Iowa | 19049 | 6 | 0 |
8617 | 8617 | 2020-03-23 | Dallas | Iowa | 19049 | 6 | 0 |
9895 | 9895 | 2020-03-24 | Dallas | Iowa | 19049 | 7 | 0 |
11292 | 11292 | 2020-03-25 | Dallas | Iowa | 19049 | 7 | 0 |
12855 | 12855 | 2020-03-26 | Dallas | Iowa | 19049 | 7 | 0 |
14544 | 14544 | 2020-03-27 | Dallas | Iowa | 19049 | 9 | 0 |
16348 | 16348 | 2020-03-28 | Dallas | Iowa | 19049 | 15 | 0 |
18253 | 18253 | 2020-03-29 | Dallas | Iowa | 19049 | 17 | 0 |
20261 | 20261 | 2020-03-30 | Dallas | Iowa | 19049 | 21 | 0 |
22357 | 22357 | 2020-03-31 | Dallas | Iowa | 19049 | 25 | 0 |
24529 | 24529 | 2020-04-01 | Dallas | Iowa | 19049 | 27 | 0 |
26770 | 26770 | 2020-04-02 | Dallas | Iowa | 19049 | 31 | 0 |
29081 | 29081 | 2020-04-03 | Dallas | Iowa | 19049 | 33 | 0 |
31449 | 31449 | 2020-04-04 | Dallas | Iowa | 19049 | 33 | 0 |
33861 | 33861 | 2020-04-05 | Dallas | Iowa | 19049 | 35 | 0 |
36315 | 36315 | 2020-04-06 | Dallas | Iowa | 19049 | 35 | 0 |
38814 | 38814 | 2020-04-07 | Dallas | Iowa | 19049 | 35 | 0 |
41360 | 41360 | 2020-04-08 | Dallas | Iowa | 19049 | 35 | 0 |
43936 | 43936 | 2020-04-09 | Dallas | Iowa | 19049 | 36 | 0 |
46541 | 46541 | 2020-04-10 | Dallas | Iowa | 19049 | 36 | 0 |
49175 | 49175 | 2020-04-11 | Dallas | Iowa | 19049 | 37 | 0 |
51839 | 51839 | 2020-04-12 | Dallas | Iowa | 19049 | 37 | 0 |
54521 | 54521 | 2020-04-13 | Dallas | Iowa | 19049 | 36 | 0 |
57214 | 57214 | 2020-04-14 | Dallas | Iowa | 19049 | 37 | 0 |
59922 | 59922 | 2020-04-15 | Dallas | Iowa | 19049 | 38 | 0 |
62643 | 62643 | 2020-04-16 | Dallas | Iowa | 19049 | 42 | 0 |
65377 | 65377 | 2020-04-17 | Dallas | Iowa | 19049 | 44 | 0 |
68126 | 68126 | 2020-04-18 | Dallas | Iowa | 19049 | 45 | 0 |
70888 | 70888 | 2020-04-19 | Dallas | Iowa | 19049 | 45 | 0 |
73659 | 73659 | 2020-04-20 | Dallas | Iowa | 19049 | 52 | 0 |
76437 | 76437 | 2020-04-21 | Dallas | Iowa | 19049 | 55 | 0 |
79221 | 79221 | 2020-04-22 | Dallas | Iowa | 19049 | 59 | 0 |
82014 | 82014 | 2020-04-23 | Dallas | Iowa | 19049 | 67 | 0 |
84814 | 84814 | 2020-04-24 | Dallas | Iowa | 19049 | 99 | 0 |
87624 | 87624 | 2020-04-25 | Dallas | Iowa | 19049 | 131 | 0 |
90440 | 90440 | 2020-04-26 | Dallas | Iowa | 19049 | 169 | 0 |
93259 | 93259 | 2020-04-27 | Dallas | Iowa | 19049 | 179 | 0 |
96091 | 96091 | 2020-04-28 | Dallas | Iowa | 19049 | 198 | 0 |
98935 | 98935 | 2020-04-29 | Dallas | Iowa | 19049 | 258 | 0 |
101786 | 101786 | 2020-04-30 | Dallas | Iowa | 19049 | 318 | 0 |
104643 | 104643 | 2020-05-01 | Dallas | Iowa | 19049 | 408 | 0 |
107508 | 107508 | 2020-05-02 | Dallas | Iowa | 19049 | 515 | 0 |
110378 | 110378 | 2020-05-03 | Dallas | Iowa | 19049 | 537 | 0 |
113253 | 113253 | 2020-05-04 | Dallas | Iowa | 19049 | 578 | 1 |
116136 | 116136 | 2020-05-05 | Dallas | Iowa | 19049 | 613 | 3 |
119096 | 119096 | 2020-05-06 | Dallas | Iowa | 19049 | 626 | 3 |
122066 | 122066 | 2020-05-07 | Dallas | Iowa | 19049 | 644 | 4 |
125046 | 125046 | 2020-05-08 | Dallas | Iowa | 19049 | 654 | 5 |
128033 | 128033 | 2020-05-09 | Dallas | Iowa | 19049 | 660 | 5 |
131024 | 131024 | 2020-05-10 | Dallas | Iowa | 19049 | 676 | 6 |
134014 | 134014 | 2020-05-11 | Dallas | Iowa | 19049 | 701 | 6 |
137003 | 137003 | 2020-05-12 | Dallas | Iowa | 19049 | 712 | 7 |
139995 | 139995 | 2020-05-13 | Dallas | Iowa | 19049 | 741 | 8 |
142991 | 142991 | 2020-05-14 | Dallas | Iowa | 19049 | 755 | 9 |
145991 | 145991 | 2020-05-15 | Dallas | Iowa | 19049 | 757 | 10 |
148995 | 148995 | 2020-05-16 | Dallas | Iowa | 19049 | 773 | 10 |
152005 | 152005 | 2020-05-17 | Dallas | Iowa | 19049 | 776 | 11 |
155017 | 155017 | 2020-05-18 | Dallas | Iowa | 19049 | 788 | 11 |
158033 | 158033 | 2020-05-19 | Dallas | Iowa | 19049 | 795 | 11 |
161059 | 161059 | 2020-05-20 | Dallas | Iowa | 19049 | 807 | 12 |
164087 | 164087 | 2020-05-21 | Dallas | Iowa | 19049 | 816 | 13 |
167120 | 167120 | 2020-05-22 | Dallas | Iowa | 19049 | 821 | 14 |
170157 | 170157 | 2020-05-23 | Dallas | Iowa | 19049 | 821 | 14 |
173198 | 173198 | 2020-05-24 | Dallas | Iowa | 19049 | 853 | 14 |
176242 | 176242 | 2020-05-25 | Dallas | Iowa | 19049 | 865 | 15 |
179286 | 179286 | 2020-05-26 | Dallas | Iowa | 19049 | 864 | 17 |
182330 | 182330 | 2020-05-27 | Dallas | Iowa | 19049 | 874 | 17 |
185384 | 185384 | 2020-05-28 | Dallas | Iowa | 19049 | 879 | 17 |
188442 | 188442 | 2020-05-29 | Dallas | Iowa | 19049 | 888 | 20 |
191507 | 191507 | 2020-05-30 | Dallas | Iowa | 19049 | 900 | 20 |
194574 | 194574 | 2020-05-31 | Dallas | Iowa | 19049 | 905 | 21 |
197644 | 197644 | 2020-06-01 | Dallas | Iowa | 19049 | 916 | 24 |
200717 | 200717 | 2020-06-02 | Dallas | Iowa | 19049 | 925 | 24 |
203793 | 203793 | 2020-06-03 | Dallas | Iowa | 19049 | 929 | 24 |
206873 | 206873 | 2020-06-04 | Dallas | Iowa | 19049 | 948 | 26 |
209954 | 209954 | 2020-06-05 | Dallas | Iowa | 19049 | 958 | 26 |
213039 | 213039 | 2020-06-06 | Dallas | Iowa | 19049 | 959 | 26 |
216126 | 216126 | 2020-06-07 | Dallas | Iowa | 19049 | 959 | 26 |
219218 | 219218 | 2020-06-08 | Dallas | Iowa | 19049 | 962 | 26 |
222313 | 222313 | 2020-06-09 | Dallas | Iowa | 19049 | 969 | 26 |
225408 | 225408 | 2020-06-10 | Dallas | Iowa | 19049 | 974 | 26 |
228510 | 228510 | 2020-06-11 | Dallas | Iowa | 19049 | 986 | 26 |
231613 | 231613 | 2020-06-12 | Dallas | Iowa | 19049 | 1005 | 26 |
234719 | 234719 | 2020-06-13 | Dallas | Iowa | 19049 | 1019 | 26 |
237826 | 237826 | 2020-06-14 | Dallas | Iowa | 19049 | 1026 | 26 |
240934 | 240934 | 2020-06-15 | Dallas | Iowa | 19049 | 1029 | 26 |
244045 | 244045 | 2020-06-16 | Dallas | Iowa | 19049 | 1031 | 28 |
247158 | 247158 | 2020-06-17 | Dallas | Iowa | 19049 | 1046 | 29 |
250270 | 250270 | 2020-06-18 | Dallas | Iowa | 19049 | 1051 | 28 |
253385 | 253385 | 2020-06-19 | Dallas | Iowa | 19049 | 1064 | 28 |
256505 | 256505 | 2020-06-20 | Dallas | Iowa | 19049 | 1067 | 29 |
259631 | 259631 | 2020-06-21 | Dallas | Iowa | 19049 | 1073 | 29 |
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);