ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Johnson" and fips = 48251 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
5061 | 5061 | 2020-03-19 | Johnson | Texas | 48251 | 2 | 0 |
5954 | 5954 | 2020-03-20 | Johnson | Texas | 48251 | 2 | 0 |
6974 | 6974 | 2020-03-21 | Johnson | Texas | 48251 | 2 | 0 |
8104 | 8104 | 2020-03-22 | Johnson | Texas | 48251 | 2 | 0 |
9322 | 9322 | 2020-03-23 | Johnson | Texas | 48251 | 2 | 0 |
10662 | 10662 | 2020-03-24 | Johnson | Texas | 48251 | 2 | 0 |
12157 | 12157 | 2020-03-25 | Johnson | Texas | 48251 | 3 | 0 |
13787 | 13787 | 2020-03-26 | Johnson | Texas | 48251 | 3 | 0 |
15543 | 15543 | 2020-03-27 | Johnson | Texas | 48251 | 6 | 0 |
17412 | 17412 | 2020-03-28 | Johnson | Texas | 48251 | 8 | 0 |
19366 | 19366 | 2020-03-29 | Johnson | Texas | 48251 | 8 | 0 |
21426 | 21426 | 2020-03-30 | Johnson | Texas | 48251 | 8 | 0 |
23565 | 23565 | 2020-03-31 | Johnson | Texas | 48251 | 8 | 0 |
25775 | 25775 | 2020-04-01 | Johnson | Texas | 48251 | 12 | 0 |
28060 | 28060 | 2020-04-02 | Johnson | Texas | 48251 | 17 | 0 |
30395 | 30395 | 2020-04-03 | Johnson | Texas | 48251 | 18 | 0 |
32790 | 32790 | 2020-04-04 | Johnson | Texas | 48251 | 20 | 0 |
35228 | 35228 | 2020-04-05 | Johnson | Texas | 48251 | 20 | 0 |
37704 | 37704 | 2020-04-06 | Johnson | Texas | 48251 | 22 | 0 |
40231 | 40231 | 2020-04-07 | Johnson | Texas | 48251 | 27 | 0 |
42798 | 42798 | 2020-04-08 | Johnson | Texas | 48251 | 30 | 0 |
45388 | 45388 | 2020-04-09 | Johnson | Texas | 48251 | 30 | 0 |
48009 | 48009 | 2020-04-10 | Johnson | Texas | 48251 | 32 | 0 |
50667 | 50667 | 2020-04-11 | Johnson | Texas | 48251 | 32 | 0 |
53342 | 53342 | 2020-04-12 | Johnson | Texas | 48251 | 32 | 0 |
56030 | 56030 | 2020-04-13 | Johnson | Texas | 48251 | 35 | 1 |
58735 | 58735 | 2020-04-14 | Johnson | Texas | 48251 | 39 | 1 |
61453 | 61453 | 2020-04-15 | Johnson | Texas | 48251 | 42 | 1 |
64180 | 64180 | 2020-04-16 | Johnson | Texas | 48251 | 44 | 1 |
69687 | 69687 | 2020-04-18 | Johnson | Texas | 48251 | 44 | 1 |
72456 | 72456 | 2020-04-19 | Johnson | Texas | 48251 | 44 | 1 |
75232 | 75232 | 2020-04-20 | Johnson | Texas | 48251 | 44 | 1 |
66927 | 66927 | 2020-04-17 | Johnson | Texas | 48251 | 45 | 1 |
78014 | 78014 | 2020-04-21 | Johnson | Texas | 48251 | 52 | 1 |
80805 | 80805 | 2020-04-22 | Johnson | Texas | 48251 | 61 | 1 |
83606 | 83606 | 2020-04-23 | Johnson | Texas | 48251 | 61 | 1 |
86411 | 86411 | 2020-04-24 | Johnson | Texas | 48251 | 61 | 1 |
89226 | 89226 | 2020-04-25 | Johnson | Texas | 48251 | 63 | 1 |
92043 | 92043 | 2020-04-26 | Johnson | Texas | 48251 | 64 | 1 |
94872 | 94872 | 2020-04-27 | Johnson | Texas | 48251 | 64 | 2 |
97712 | 97712 | 2020-04-28 | Johnson | Texas | 48251 | 73 | 3 |
100562 | 100562 | 2020-04-29 | Johnson | Texas | 48251 | 81 | 4 |
103417 | 103417 | 2020-04-30 | Johnson | Texas | 48251 | 82 | 4 |
106281 | 106281 | 2020-05-01 | Johnson | Texas | 48251 | 90 | 4 |
109150 | 109150 | 2020-05-02 | Johnson | Texas | 48251 | 90 | 4 |
112024 | 112024 | 2020-05-03 | Johnson | Texas | 48251 | 90 | 4 |
114906 | 114906 | 2020-05-04 | Johnson | Texas | 48251 | 97 | 4 |
117865 | 117865 | 2020-05-05 | Johnson | Texas | 48251 | 102 | 4 |
120829 | 120829 | 2020-05-06 | Johnson | Texas | 48251 | 102 | 4 |
126791 | 126791 | 2020-05-08 | Johnson | Texas | 48251 | 114 | 4 |
129780 | 129780 | 2020-05-09 | Johnson | Texas | 48251 | 114 | 4 |
132770 | 132770 | 2020-05-10 | Johnson | Texas | 48251 | 114 | 4 |
135761 | 135761 | 2020-05-11 | Johnson | Texas | 48251 | 117 | 4 |
138751 | 138751 | 2020-05-12 | Johnson | Texas | 48251 | 121 | 4 |
141747 | 141747 | 2020-05-13 | Johnson | Texas | 48251 | 121 | 4 |
144744 | 144744 | 2020-05-14 | Johnson | Texas | 48251 | 124 | 4 |
147748 | 147748 | 2020-05-15 | Johnson | Texas | 48251 | 132 | 4 |
150756 | 150756 | 2020-05-16 | Johnson | Texas | 48251 | 132 | 4 |
153767 | 153767 | 2020-05-17 | Johnson | Texas | 48251 | 132 | 4 |
156784 | 156784 | 2020-05-18 | Johnson | Texas | 48251 | 148 | 4 |
123808 | 123808 | 2020-05-07 | Johnson | Texas | 48251 | 150 | 4 |
159806 | 159806 | 2020-05-19 | Johnson | Texas | 48251 | 161 | 4 |
162834 | 162834 | 2020-05-20 | Johnson | Texas | 48251 | 161 | 4 |
165863 | 165863 | 2020-05-21 | Johnson | Texas | 48251 | 161 | 4 |
168899 | 168899 | 2020-05-22 | Johnson | Texas | 48251 | 173 | 4 |
171939 | 171939 | 2020-05-23 | Johnson | Texas | 48251 | 173 | 4 |
174982 | 174982 | 2020-05-24 | Johnson | Texas | 48251 | 173 | 4 |
178026 | 178026 | 2020-05-25 | Johnson | Texas | 48251 | 173 | 4 |
181070 | 181070 | 2020-05-26 | Johnson | Texas | 48251 | 173 | 4 |
184120 | 184120 | 2020-05-27 | Johnson | Texas | 48251 | 173 | 4 |
187177 | 187177 | 2020-05-28 | Johnson | Texas | 48251 | 192 | 4 |
190241 | 190241 | 2020-05-29 | Johnson | Texas | 48251 | 195 | 4 |
193306 | 193306 | 2020-05-30 | Johnson | Texas | 48251 | 195 | 4 |
196376 | 196376 | 2020-05-31 | Johnson | Texas | 48251 | 195 | 4 |
199449 | 199449 | 2020-06-01 | Johnson | Texas | 48251 | 199 | 4 |
202525 | 202525 | 2020-06-02 | Johnson | Texas | 48251 | 202 | 4 |
205604 | 205604 | 2020-06-03 | Johnson | Texas | 48251 | 204 | 4 |
208686 | 208686 | 2020-06-04 | Johnson | Texas | 48251 | 206 | 4 |
211770 | 211770 | 2020-06-05 | Johnson | Texas | 48251 | 216 | 4 |
214857 | 214857 | 2020-06-06 | Johnson | Texas | 48251 | 216 | 4 |
217947 | 217947 | 2020-06-07 | Johnson | Texas | 48251 | 216 | 3 |
221039 | 221039 | 2020-06-08 | Johnson | Texas | 48251 | 216 | 3 |
224134 | 224134 | 2020-06-09 | Johnson | Texas | 48251 | 235 | 3 |
227234 | 227234 | 2020-06-10 | Johnson | Texas | 48251 | 242 | 3 |
230338 | 230338 | 2020-06-11 | Johnson | Texas | 48251 | 246 | 3 |
233442 | 233442 | 2020-06-12 | Johnson | Texas | 48251 | 256 | 3 |
236548 | 236548 | 2020-06-13 | Johnson | Texas | 48251 | 256 | 3 |
239656 | 239656 | 2020-06-14 | Johnson | Texas | 48251 | 256 | 3 |
242766 | 242766 | 2020-06-15 | Johnson | Texas | 48251 | 272 | 3 |
245878 | 245878 | 2020-06-16 | Johnson | Texas | 48251 | 278 | 4 |
248991 | 248991 | 2020-06-17 | Johnson | Texas | 48251 | 282 | 4 |
252106 | 252106 | 2020-06-18 | Johnson | Texas | 48251 | 282 | 4 |
255221 | 255221 | 2020-06-19 | Johnson | Texas | 48251 | 298 | 4 |
258348 | 258348 | 2020-06-20 | Johnson | Texas | 48251 | 298 | 4 |
261475 | 261475 | 2020-06-21 | Johnson | Texas | 48251 | 298 | 4 |
264603 | 264603 | 2020-06-22 | Johnson | Texas | 48251 | 328 | 4 |
267731 | 267731 | 2020-06-23 | Johnson | Texas | 48251 | 328 | 4 |
270865 | 270865 | 2020-06-24 | Johnson | Texas | 48251 | 328 | 4 |
274005 | 274005 | 2020-06-25 | Johnson | Texas | 48251 | 328 | 4 |
277153 | 277153 | 2020-06-26 | Johnson | Texas | 48251 | 328 | 4 |
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);