ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 19113 and state = "Iowa" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
6404 | 6404 | 2020-03-21 | Linn | Iowa | 19113 | 3 | 0 |
7466 | 7466 | 2020-03-22 | Linn | Iowa | 19113 | 4 | 0 |
8625 | 8625 | 2020-03-23 | Linn | Iowa | 19113 | 6 | 0 |
9904 | 9904 | 2020-03-24 | Linn | Iowa | 19113 | 6 | 0 |
11301 | 11301 | 2020-03-25 | Linn | Iowa | 19113 | 7 | 0 |
12865 | 12865 | 2020-03-26 | Linn | Iowa | 19113 | 12 | 0 |
14557 | 14557 | 2020-03-27 | Linn | Iowa | 19113 | 22 | 0 |
16362 | 16362 | 2020-03-28 | Linn | Iowa | 19113 | 36 | 0 |
18267 | 18267 | 2020-03-29 | Linn | Iowa | 19113 | 42 | 1 |
20278 | 20278 | 2020-03-30 | Linn | Iowa | 19113 | 71 | 2 |
22374 | 22374 | 2020-03-31 | Linn | Iowa | 19113 | 90 | 2 |
24546 | 24546 | 2020-04-01 | Linn | Iowa | 19113 | 94 | 2 |
26788 | 26788 | 2020-04-02 | Linn | Iowa | 19113 | 105 | 4 |
29099 | 29099 | 2020-04-03 | Linn | Iowa | 19113 | 118 | 4 |
31470 | 31470 | 2020-04-04 | Linn | Iowa | 19113 | 139 | 4 |
33883 | 33883 | 2020-04-05 | Linn | Iowa | 19113 | 161 | 6 |
36338 | 36338 | 2020-04-06 | Linn | Iowa | 19113 | 176 | 8 |
38839 | 38839 | 2020-04-07 | Linn | Iowa | 19113 | 186 | 8 |
41385 | 41385 | 2020-04-08 | Linn | Iowa | 19113 | 197 | 9 |
43961 | 43961 | 2020-04-09 | Linn | Iowa | 19113 | 215 | 9 |
46566 | 46566 | 2020-04-10 | Linn | Iowa | 19113 | 225 | 12 |
49200 | 49200 | 2020-04-11 | Linn | Iowa | 19113 | 235 | 12 |
51864 | 51864 | 2020-04-12 | Linn | Iowa | 19113 | 243 | 18 |
54546 | 54546 | 2020-04-13 | Linn | Iowa | 19113 | 258 | 19 |
57239 | 57239 | 2020-04-14 | Linn | Iowa | 19113 | 265 | 19 |
59947 | 59947 | 2020-04-15 | Linn | Iowa | 19113 | 276 | 21 |
62668 | 62668 | 2020-04-16 | Linn | Iowa | 19113 | 280 | 22 |
65402 | 65402 | 2020-04-17 | Linn | Iowa | 19113 | 304 | 22 |
68151 | 68151 | 2020-04-18 | Linn | Iowa | 19113 | 332 | 25 |
70913 | 70913 | 2020-04-19 | Linn | Iowa | 19113 | 397 | 25 |
73684 | 73684 | 2020-04-20 | Linn | Iowa | 19113 | 411 | 27 |
76463 | 76463 | 2020-04-21 | Linn | Iowa | 19113 | 462 | 27 |
79247 | 79247 | 2020-04-22 | Linn | Iowa | 19113 | 469 | 29 |
82040 | 82040 | 2020-04-23 | Linn | Iowa | 19113 | 481 | 29 |
84840 | 84840 | 2020-04-24 | Linn | Iowa | 19113 | 511 | 32 |
87650 | 87650 | 2020-04-25 | Linn | Iowa | 19113 | 550 | 33 |
90466 | 90466 | 2020-04-26 | Linn | Iowa | 19113 | 575 | 34 |
93285 | 93285 | 2020-04-27 | Linn | Iowa | 19113 | 613 | 34 |
96117 | 96117 | 2020-04-28 | Linn | Iowa | 19113 | 632 | 36 |
98962 | 98962 | 2020-04-29 | Linn | Iowa | 19113 | 652 | 40 |
101813 | 101813 | 2020-04-30 | Linn | Iowa | 19113 | 669 | 43 |
104671 | 104671 | 2020-05-01 | Linn | Iowa | 19113 | 673 | 45 |
107536 | 107536 | 2020-05-02 | Linn | Iowa | 19113 | 705 | 47 |
110406 | 110406 | 2020-05-03 | Linn | Iowa | 19113 | 731 | 47 |
113281 | 113281 | 2020-05-04 | Linn | Iowa | 19113 | 757 | 47 |
116164 | 116164 | 2020-05-05 | Linn | Iowa | 19113 | 767 | 53 |
119124 | 119124 | 2020-05-06 | Linn | Iowa | 19113 | 770 | 55 |
122094 | 122094 | 2020-05-07 | Linn | Iowa | 19113 | 805 | 56 |
125075 | 125075 | 2020-05-08 | Linn | Iowa | 19113 | 813 | 58 |
128062 | 128062 | 2020-05-09 | Linn | Iowa | 19113 | 819 | 58 |
131053 | 131053 | 2020-05-10 | Linn | Iowa | 19113 | 827 | 58 |
134043 | 134043 | 2020-05-11 | Linn | Iowa | 19113 | 841 | 59 |
137033 | 137033 | 2020-05-12 | Linn | Iowa | 19113 | 849 | 62 |
140026 | 140026 | 2020-05-13 | Linn | Iowa | 19113 | 858 | 63 |
143022 | 143022 | 2020-05-14 | Linn | Iowa | 19113 | 871 | 65 |
146022 | 146022 | 2020-05-15 | Linn | Iowa | 19113 | 882 | 69 |
149026 | 149026 | 2020-05-16 | Linn | Iowa | 19113 | 892 | 70 |
152036 | 152036 | 2020-05-17 | Linn | Iowa | 19113 | 896 | 70 |
155048 | 155048 | 2020-05-18 | Linn | Iowa | 19113 | 899 | 70 |
158064 | 158064 | 2020-05-19 | Linn | Iowa | 19113 | 899 | 73 |
161090 | 161090 | 2020-05-20 | Linn | Iowa | 19113 | 902 | 73 |
164118 | 164118 | 2020-05-21 | Linn | Iowa | 19113 | 910 | 74 |
167151 | 167151 | 2020-05-22 | Linn | Iowa | 19113 | 917 | 75 |
170188 | 170188 | 2020-05-23 | Linn | Iowa | 19113 | 917 | 75 |
173229 | 173229 | 2020-05-24 | Linn | Iowa | 19113 | 932 | 75 |
176273 | 176273 | 2020-05-25 | Linn | Iowa | 19113 | 935 | 75 |
179317 | 179317 | 2020-05-26 | Linn | Iowa | 19113 | 936 | 76 |
182362 | 182362 | 2020-05-27 | Linn | Iowa | 19113 | 940 | 76 |
185416 | 185416 | 2020-05-28 | Linn | Iowa | 19113 | 942 | 76 |
188474 | 188474 | 2020-05-29 | Linn | Iowa | 19113 | 947 | 76 |
191539 | 191539 | 2020-05-30 | Linn | Iowa | 19113 | 952 | 76 |
194606 | 194606 | 2020-05-31 | Linn | Iowa | 19113 | 955 | 79 |
197676 | 197676 | 2020-06-01 | Linn | Iowa | 19113 | 955 | 79 |
200749 | 200749 | 2020-06-02 | Linn | Iowa | 19113 | 958 | 79 |
203825 | 203825 | 2020-06-03 | Linn | Iowa | 19113 | 967 | 79 |
206905 | 206905 | 2020-06-04 | Linn | Iowa | 19113 | 974 | 79 |
209986 | 209986 | 2020-06-05 | Linn | Iowa | 19113 | 978 | 79 |
213071 | 213071 | 2020-06-06 | Linn | Iowa | 19113 | 983 | 80 |
216158 | 216158 | 2020-06-07 | Linn | Iowa | 19113 | 987 | 80 |
219250 | 219250 | 2020-06-08 | Linn | Iowa | 19113 | 1000 | 80 |
222345 | 222345 | 2020-06-09 | Linn | Iowa | 19113 | 1002 | 80 |
225440 | 225440 | 2020-06-10 | Linn | Iowa | 19113 | 1007 | 80 |
228542 | 228542 | 2020-06-11 | Linn | Iowa | 19113 | 1010 | 80 |
231645 | 231645 | 2020-06-12 | Linn | Iowa | 19113 | 1014 | 80 |
234751 | 234751 | 2020-06-13 | Linn | Iowa | 19113 | 1017 | 80 |
237858 | 237858 | 2020-06-14 | Linn | Iowa | 19113 | 1018 | 80 |
240966 | 240966 | 2020-06-15 | Linn | Iowa | 19113 | 1019 | 80 |
244077 | 244077 | 2020-06-16 | Linn | Iowa | 19113 | 1023 | 80 |
247190 | 247190 | 2020-06-17 | Linn | Iowa | 19113 | 1042 | 80 |
250302 | 250302 | 2020-06-18 | Linn | Iowa | 19113 | 1051 | 80 |
253417 | 253417 | 2020-06-19 | Linn | Iowa | 19113 | 1066 | 80 |
256537 | 256537 | 2020-06-20 | Linn | Iowa | 19113 | 1077 | 80 |
259663 | 259663 | 2020-06-21 | Linn | Iowa | 19113 | 1096 | 80 |
262790 | 262790 | 2020-06-22 | Linn | Iowa | 19113 | 1103 | 80 |
265918 | 265918 | 2020-06-23 | Linn | Iowa | 19113 | 1107 | 80 |
269048 | 269048 | 2020-06-24 | Linn | Iowa | 19113 | 1126 | 80 |
272185 | 272185 | 2020-06-25 | Linn | Iowa | 19113 | 1152 | 81 |
275327 | 275327 | 2020-06-26 | Linn | Iowa | 19113 | 1161 | 82 |
278475 | 278475 | 2020-06-27 | Linn | Iowa | 19113 | 1172 | 82 |
281623 | 281623 | 2020-06-28 | Linn | Iowa | 19113 | 1181 | 82 |
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);