ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Monroe" and state = "Illinois" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- …
state 1
- Illinois · 782 ✖
fips 1
- 17133 782
county 1
- Monroe · 782 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
8559 | 8559 | 2020-03-23 | Monroe | Illinois | 17133 | 1 | 0 |
9823 | 9823 | 2020-03-24 | Monroe | Illinois | 17133 | 1 | 0 |
11215 | 11215 | 2020-03-25 | Monroe | Illinois | 17133 | 2 | 0 |
12771 | 12771 | 2020-03-26 | Monroe | Illinois | 17133 | 3 | 0 |
14449 | 14449 | 2020-03-27 | Monroe | Illinois | 17133 | 3 | 0 |
16245 | 16245 | 2020-03-28 | Monroe | Illinois | 17133 | 3 | 0 |
18146 | 18146 | 2020-03-29 | Monroe | Illinois | 17133 | 3 | 0 |
20149 | 20149 | 2020-03-30 | Monroe | Illinois | 17133 | 3 | 0 |
22241 | 22241 | 2020-03-31 | Monroe | Illinois | 17133 | 3 | 0 |
24410 | 24410 | 2020-04-01 | Monroe | Illinois | 17133 | 3 | 0 |
26646 | 26646 | 2020-04-02 | Monroe | Illinois | 17133 | 4 | 0 |
28956 | 28956 | 2020-04-03 | Monroe | Illinois | 17133 | 8 | 0 |
31321 | 31321 | 2020-04-04 | Monroe | Illinois | 17133 | 9 | 0 |
33731 | 33731 | 2020-04-05 | Monroe | Illinois | 17133 | 10 | 0 |
36183 | 36183 | 2020-04-06 | Monroe | Illinois | 17133 | 11 | 0 |
38679 | 38679 | 2020-04-07 | Monroe | Illinois | 17133 | 12 | 1 |
41224 | 41224 | 2020-04-08 | Monroe | Illinois | 17133 | 20 | 1 |
43798 | 43798 | 2020-04-09 | Monroe | Illinois | 17133 | 35 | 1 |
46402 | 46402 | 2020-04-10 | Monroe | Illinois | 17133 | 42 | 1 |
49034 | 49034 | 2020-04-11 | Monroe | Illinois | 17133 | 43 | 1 |
51696 | 51696 | 2020-04-12 | Monroe | Illinois | 17133 | 46 | 1 |
54377 | 54377 | 2020-04-13 | Monroe | Illinois | 17133 | 46 | 1 |
57070 | 57070 | 2020-04-14 | Monroe | Illinois | 17133 | 47 | 3 |
59777 | 59777 | 2020-04-15 | Monroe | Illinois | 17133 | 49 | 4 |
62498 | 62498 | 2020-04-16 | Monroe | Illinois | 17133 | 50 | 5 |
65231 | 65231 | 2020-04-17 | Monroe | Illinois | 17133 | 52 | 6 |
67980 | 67980 | 2020-04-18 | Monroe | Illinois | 17133 | 52 | 7 |
70742 | 70742 | 2020-04-19 | Monroe | Illinois | 17133 | 53 | 7 |
73512 | 73512 | 2020-04-20 | Monroe | Illinois | 17133 | 54 | 7 |
76289 | 76289 | 2020-04-21 | Monroe | Illinois | 17133 | 55 | 7 |
79073 | 79073 | 2020-04-22 | Monroe | Illinois | 17133 | 58 | 8 |
81866 | 81866 | 2020-04-23 | Monroe | Illinois | 17133 | 60 | 8 |
84666 | 84666 | 2020-04-24 | Monroe | Illinois | 17133 | 62 | 8 |
87476 | 87476 | 2020-04-25 | Monroe | Illinois | 17133 | 63 | 10 |
90292 | 90292 | 2020-04-26 | Monroe | Illinois | 17133 | 64 | 10 |
93111 | 93111 | 2020-04-27 | Monroe | Illinois | 17133 | 64 | 10 |
95943 | 95943 | 2020-04-28 | Monroe | Illinois | 17133 | 67 | 10 |
98787 | 98787 | 2020-04-29 | Monroe | Illinois | 17133 | 69 | 10 |
101638 | 101638 | 2020-04-30 | Monroe | Illinois | 17133 | 70 | 10 |
104494 | 104494 | 2020-05-01 | Monroe | Illinois | 17133 | 71 | 10 |
107359 | 107359 | 2020-05-02 | Monroe | Illinois | 17133 | 71 | 10 |
113104 | 113104 | 2020-05-04 | Monroe | Illinois | 17133 | 73 | 12 |
115987 | 115987 | 2020-05-05 | Monroe | Illinois | 17133 | 74 | 11 |
118947 | 118947 | 2020-05-06 | Monroe | Illinois | 17133 | 74 | 11 |
110229 | 110229 | 2020-05-03 | Monroe | Illinois | 17133 | 75 | 11 |
121917 | 121917 | 2020-05-07 | Monroe | Illinois | 17133 | 77 | 11 |
124896 | 124896 | 2020-05-08 | Monroe | Illinois | 17133 | 79 | 11 |
127883 | 127883 | 2020-05-09 | Monroe | Illinois | 17133 | 79 | 11 |
130874 | 130874 | 2020-05-10 | Monroe | Illinois | 17133 | 79 | 11 |
133865 | 133865 | 2020-05-11 | Monroe | Illinois | 17133 | 79 | 11 |
136854 | 136854 | 2020-05-12 | Monroe | Illinois | 17133 | 81 | 11 |
139846 | 139846 | 2020-05-13 | Monroe | Illinois | 17133 | 81 | 11 |
142842 | 142842 | 2020-05-14 | Monroe | Illinois | 17133 | 82 | 11 |
145842 | 145842 | 2020-05-15 | Monroe | Illinois | 17133 | 83 | 11 |
148845 | 148845 | 2020-05-16 | Monroe | Illinois | 17133 | 86 | 11 |
151854 | 151854 | 2020-05-17 | Monroe | Illinois | 17133 | 87 | 11 |
154866 | 154866 | 2020-05-18 | Monroe | Illinois | 17133 | 89 | 11 |
157882 | 157882 | 2020-05-19 | Monroe | Illinois | 17133 | 90 | 11 |
160908 | 160908 | 2020-05-20 | Monroe | Illinois | 17133 | 90 | 11 |
163936 | 163936 | 2020-05-21 | Monroe | Illinois | 17133 | 90 | 11 |
166969 | 166969 | 2020-05-22 | Monroe | Illinois | 17133 | 91 | 11 |
170006 | 170006 | 2020-05-23 | Monroe | Illinois | 17133 | 91 | 11 |
173047 | 173047 | 2020-05-24 | Monroe | Illinois | 17133 | 91 | 11 |
176091 | 176091 | 2020-05-25 | Monroe | Illinois | 17133 | 92 | 11 |
179135 | 179135 | 2020-05-26 | Monroe | Illinois | 17133 | 92 | 11 |
182179 | 182179 | 2020-05-27 | Monroe | Illinois | 17133 | 93 | 11 |
185233 | 185233 | 2020-05-28 | Monroe | Illinois | 17133 | 93 | 11 |
188291 | 188291 | 2020-05-29 | Monroe | Illinois | 17133 | 94 | 11 |
191356 | 191356 | 2020-05-30 | Monroe | Illinois | 17133 | 95 | 11 |
194423 | 194423 | 2020-05-31 | Monroe | Illinois | 17133 | 95 | 12 |
197493 | 197493 | 2020-06-01 | Monroe | Illinois | 17133 | 96 | 12 |
200566 | 200566 | 2020-06-02 | Monroe | Illinois | 17133 | 96 | 12 |
203642 | 203642 | 2020-06-03 | Monroe | Illinois | 17133 | 97 | 12 |
206722 | 206722 | 2020-06-04 | Monroe | Illinois | 17133 | 98 | 12 |
209803 | 209803 | 2020-06-05 | Monroe | Illinois | 17133 | 100 | 12 |
212888 | 212888 | 2020-06-06 | Monroe | Illinois | 17133 | 100 | 12 |
215975 | 215975 | 2020-06-07 | Monroe | Illinois | 17133 | 101 | 12 |
219066 | 219066 | 2020-06-08 | Monroe | Illinois | 17133 | 104 | 12 |
222161 | 222161 | 2020-06-09 | Monroe | Illinois | 17133 | 105 | 12 |
225256 | 225256 | 2020-06-10 | Monroe | Illinois | 17133 | 105 | 12 |
228358 | 228358 | 2020-06-11 | Monroe | Illinois | 17133 | 105 | 12 |
231461 | 231461 | 2020-06-12 | Monroe | Illinois | 17133 | 106 | 12 |
234567 | 234567 | 2020-06-13 | Monroe | Illinois | 17133 | 109 | 12 |
237674 | 237674 | 2020-06-14 | Monroe | Illinois | 17133 | 109 | 12 |
247006 | 247006 | 2020-06-17 | Monroe | Illinois | 17133 | 109 | 12 |
250118 | 250118 | 2020-06-18 | Monroe | Illinois | 17133 | 110 | 12 |
243893 | 243893 | 2020-06-16 | Monroe | Illinois | 17133 | 111 | 12 |
253233 | 253233 | 2020-06-19 | Monroe | Illinois | 17133 | 111 | 12 |
240782 | 240782 | 2020-06-15 | Monroe | Illinois | 17133 | 112 | 12 |
256353 | 256353 | 2020-06-20 | Monroe | Illinois | 17133 | 112 | 12 |
259479 | 259479 | 2020-06-21 | Monroe | Illinois | 17133 | 113 | 12 |
262606 | 262606 | 2020-06-22 | Monroe | Illinois | 17133 | 116 | 12 |
265734 | 265734 | 2020-06-23 | Monroe | Illinois | 17133 | 116 | 12 |
268864 | 268864 | 2020-06-24 | Monroe | Illinois | 17133 | 117 | 12 |
272001 | 272001 | 2020-06-25 | Monroe | Illinois | 17133 | 118 | 13 |
275143 | 275143 | 2020-06-26 | Monroe | Illinois | 17133 | 120 | 13 |
278291 | 278291 | 2020-06-27 | Monroe | Illinois | 17133 | 123 | 13 |
281439 | 281439 | 2020-06-28 | Monroe | Illinois | 17133 | 123 | 13 |
284584 | 284584 | 2020-06-29 | Monroe | Illinois | 17133 | 126 | 13 |
287733 | 287733 | 2020-06-30 | Monroe | Illinois | 17133 | 127 | 13 |
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);