ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Franklin" and state = "Missouri" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10203 | 10203 | 2020-03-24 | Franklin | Missouri | 29071 | 1 | 0 |
11625 | 11625 | 2020-03-25 | Franklin | Missouri | 29071 | 3 | 0 |
13223 | 13223 | 2020-03-26 | Franklin | Missouri | 29071 | 4 | 0 |
14948 | 14948 | 2020-03-27 | Franklin | Missouri | 29071 | 4 | 0 |
16772 | 16772 | 2020-03-28 | Franklin | Missouri | 29071 | 6 | 0 |
18694 | 18694 | 2020-03-29 | Franklin | Missouri | 29071 | 7 | 0 |
20720 | 20720 | 2020-03-30 | Franklin | Missouri | 29071 | 7 | 0 |
22838 | 22838 | 2020-03-31 | Franklin | Missouri | 29071 | 13 | 0 |
25025 | 25025 | 2020-04-01 | Franklin | Missouri | 29071 | 16 | 0 |
27280 | 27280 | 2020-04-02 | Franklin | Missouri | 29071 | 19 | 0 |
29600 | 29600 | 2020-04-03 | Franklin | Missouri | 29071 | 23 | 0 |
31980 | 31980 | 2020-04-04 | Franklin | Missouri | 29071 | 24 | 0 |
34408 | 34408 | 2020-04-05 | Franklin | Missouri | 29071 | 25 | 2 |
36871 | 36871 | 2020-04-06 | Franklin | Missouri | 29071 | 33 | 2 |
39383 | 39383 | 2020-04-07 | Franklin | Missouri | 29071 | 35 | 3 |
41937 | 41937 | 2020-04-08 | Franklin | Missouri | 29071 | 56 | 3 |
44514 | 44514 | 2020-04-09 | Franklin | Missouri | 29071 | 62 | 3 |
47123 | 47123 | 2020-04-10 | Franklin | Missouri | 29071 | 68 | 3 |
49770 | 49770 | 2020-04-11 | Franklin | Missouri | 29071 | 75 | 3 |
52443 | 52443 | 2020-04-12 | Franklin | Missouri | 29071 | 81 | 3 |
55125 | 55125 | 2020-04-13 | Franklin | Missouri | 29071 | 84 | 3 |
57823 | 57823 | 2020-04-14 | Franklin | Missouri | 29071 | 84 | 3 |
60535 | 60535 | 2020-04-15 | Franklin | Missouri | 29071 | 83 | 3 |
63257 | 63257 | 2020-04-16 | Franklin | Missouri | 29071 | 89 | 3 |
65997 | 65997 | 2020-04-17 | Franklin | Missouri | 29071 | 91 | 5 |
68749 | 68749 | 2020-04-18 | Franklin | Missouri | 29071 | 95 | 5 |
71516 | 71516 | 2020-04-19 | Franklin | Missouri | 29071 | 98 | 5 |
74289 | 74289 | 2020-04-20 | Franklin | Missouri | 29071 | 99 | 5 |
77070 | 77070 | 2020-04-21 | Franklin | Missouri | 29071 | 102 | 5 |
79856 | 79856 | 2020-04-22 | Franklin | Missouri | 29071 | 102 | 5 |
82652 | 82652 | 2020-04-23 | Franklin | Missouri | 29071 | 103 | 5 |
85456 | 85456 | 2020-04-24 | Franklin | Missouri | 29071 | 106 | 5 |
88266 | 88266 | 2020-04-25 | Franklin | Missouri | 29071 | 106 | 6 |
91082 | 91082 | 2020-04-26 | Franklin | Missouri | 29071 | 106 | 6 |
93903 | 93903 | 2020-04-27 | Franklin | Missouri | 29071 | 106 | 6 |
96739 | 96739 | 2020-04-28 | Franklin | Missouri | 29071 | 110 | 6 |
99585 | 99585 | 2020-04-29 | Franklin | Missouri | 29071 | 110 | 6 |
102437 | 102437 | 2020-04-30 | Franklin | Missouri | 29071 | 114 | 8 |
105298 | 105298 | 2020-05-01 | Franklin | Missouri | 29071 | 114 | 10 |
108163 | 108163 | 2020-05-02 | Franklin | Missouri | 29071 | 119 | 12 |
111034 | 111034 | 2020-05-03 | Franklin | Missouri | 29071 | 122 | 12 |
113913 | 113913 | 2020-05-04 | Franklin | Missouri | 29071 | 125 | 13 |
116795 | 116795 | 2020-05-05 | Franklin | Missouri | 29071 | 127 | 13 |
119755 | 119755 | 2020-05-06 | Franklin | Missouri | 29071 | 132 | 13 |
122729 | 122729 | 2020-05-07 | Franklin | Missouri | 29071 | 137 | 13 |
125711 | 125711 | 2020-05-08 | Franklin | Missouri | 29071 | 129 | 13 |
128698 | 128698 | 2020-05-09 | Franklin | Missouri | 29071 | 128 | 13 |
131688 | 131688 | 2020-05-10 | Franklin | Missouri | 29071 | 128 | 13 |
134679 | 134679 | 2020-05-11 | Franklin | Missouri | 29071 | 130 | 13 |
137669 | 137669 | 2020-05-12 | Franklin | Missouri | 29071 | 131 | 14 |
140663 | 140663 | 2020-05-13 | Franklin | Missouri | 29071 | 133 | 14 |
143658 | 143658 | 2020-05-14 | Franklin | Missouri | 29071 | 134 | 14 |
146659 | 146659 | 2020-05-15 | Franklin | Missouri | 29071 | 134 | 14 |
149664 | 149664 | 2020-05-16 | Franklin | Missouri | 29071 | 134 | 14 |
152675 | 152675 | 2020-05-17 | Franklin | Missouri | 29071 | 134 | 14 |
155689 | 155689 | 2020-05-18 | Franklin | Missouri | 29071 | 135 | 14 |
158707 | 158707 | 2020-05-19 | Franklin | Missouri | 29071 | 135 | 14 |
161733 | 161733 | 2020-05-20 | Franklin | Missouri | 29071 | 136 | 15 |
164762 | 164762 | 2020-05-21 | Franklin | Missouri | 29071 | 137 | 15 |
167798 | 167798 | 2020-05-22 | Franklin | Missouri | 29071 | 137 | 16 |
170836 | 170836 | 2020-05-23 | Franklin | Missouri | 29071 | 137 | 16 |
173878 | 173878 | 2020-05-24 | Franklin | Missouri | 29071 | 138 | 16 |
176921 | 176921 | 2020-05-25 | Franklin | Missouri | 29071 | 140 | 16 |
179965 | 179965 | 2020-05-26 | Franklin | Missouri | 29071 | 139 | 16 |
183011 | 183011 | 2020-05-27 | Franklin | Missouri | 29071 | 140 | 16 |
186067 | 186067 | 2020-05-28 | Franklin | Missouri | 29071 | 140 | 16 |
189125 | 189125 | 2020-05-29 | Franklin | Missouri | 29071 | 139 | 16 |
192189 | 192189 | 2020-05-30 | Franklin | Missouri | 29071 | 139 | 16 |
195258 | 195258 | 2020-05-31 | Franklin | Missouri | 29071 | 139 | 16 |
198329 | 198329 | 2020-06-01 | Franklin | Missouri | 29071 | 141 | 16 |
201402 | 201402 | 2020-06-02 | Franklin | Missouri | 29071 | 142 | 17 |
204479 | 204479 | 2020-06-03 | Franklin | Missouri | 29071 | 143 | 17 |
207560 | 207560 | 2020-06-04 | Franklin | Missouri | 29071 | 149 | 17 |
210641 | 210641 | 2020-06-05 | Franklin | Missouri | 29071 | 149 | 17 |
213725 | 213725 | 2020-06-06 | Franklin | Missouri | 29071 | 150 | 17 |
216813 | 216813 | 2020-06-07 | Franklin | Missouri | 29071 | 150 | 17 |
219905 | 219905 | 2020-06-08 | Franklin | Missouri | 29071 | 153 | 18 |
223000 | 223000 | 2020-06-09 | Franklin | Missouri | 29071 | 156 | 18 |
226098 | 226098 | 2020-06-10 | Franklin | Missouri | 29071 | 155 | 18 |
229201 | 229201 | 2020-06-11 | Franklin | Missouri | 29071 | 164 | 18 |
232305 | 232305 | 2020-06-12 | Franklin | Missouri | 29071 | 166 | 18 |
235411 | 235411 | 2020-06-13 | Franklin | Missouri | 29071 | 166 | 18 |
238518 | 238518 | 2020-06-14 | Franklin | Missouri | 29071 | 166 | 18 |
241628 | 241628 | 2020-06-15 | Franklin | Missouri | 29071 | 168 | 18 |
244739 | 244739 | 2020-06-16 | Franklin | Missouri | 29071 | 172 | 18 |
247852 | 247852 | 2020-06-17 | Franklin | Missouri | 29071 | 173 | 18 |
250965 | 250965 | 2020-06-18 | Franklin | Missouri | 29071 | 178 | 18 |
254080 | 254080 | 2020-06-19 | Franklin | Missouri | 29071 | 180 | 18 |
257200 | 257200 | 2020-06-20 | Franklin | Missouri | 29071 | 188 | 18 |
260326 | 260326 | 2020-06-21 | Franklin | Missouri | 29071 | 188 | 18 |
263454 | 263454 | 2020-06-22 | Franklin | Missouri | 29071 | 191 | 18 |
266580 | 266580 | 2020-06-23 | Franklin | Missouri | 29071 | 193 | 18 |
269713 | 269713 | 2020-06-24 | Franklin | Missouri | 29071 | 192 | 18 |
272851 | 272851 | 2020-06-25 | Franklin | Missouri | 29071 | 201 | 18 |
275994 | 275994 | 2020-06-26 | Franklin | Missouri | 29071 | 202 | 18 |
279142 | 279142 | 2020-06-27 | Franklin | Missouri | 29071 | 204 | 18 |
282290 | 282290 | 2020-06-28 | Franklin | Missouri | 29071 | 206 | 18 |
285435 | 285435 | 2020-06-29 | Franklin | Missouri | 29071 | 207 | 18 |
288585 | 288585 | 2020-06-30 | Franklin | Missouri | 29071 | 206 | 18 |
291736 | 291736 | 2020-07-01 | Franklin | Missouri | 29071 | 208 | 18 |
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);