ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,331 rows where county = "McLean" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 3
- Illinois 785
- North Dakota 777
- Kentucky 769
county 1
- McLean · 2,331 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
17025 | 17025 | 2020-03-28 | McLean | North Dakota | 38055 | 2 | 0 |
18959 | 18959 | 2020-03-29 | McLean | North Dakota | 38055 | 2 | 0 |
21001 | 21001 | 2020-03-30 | McLean | North Dakota | 38055 | 2 | 0 |
23132 | 23132 | 2020-03-31 | McLean | North Dakota | 38055 | 2 | 0 |
25327 | 25327 | 2020-04-01 | McLean | North Dakota | 38055 | 2 | 0 |
27593 | 27593 | 2020-04-02 | McLean | North Dakota | 38055 | 2 | 0 |
29921 | 29921 | 2020-04-03 | McLean | North Dakota | 38055 | 2 | 0 |
32309 | 32309 | 2020-04-04 | McLean | North Dakota | 38055 | 2 | 0 |
34742 | 34742 | 2020-04-05 | McLean | North Dakota | 38055 | 2 | 0 |
37211 | 37211 | 2020-04-06 | McLean | North Dakota | 38055 | 2 | 0 |
39728 | 39728 | 2020-04-07 | McLean | North Dakota | 38055 | 2 | 0 |
42285 | 42285 | 2020-04-08 | McLean | North Dakota | 38055 | 2 | 0 |
44869 | 44869 | 2020-04-09 | McLean | North Dakota | 38055 | 2 | 0 |
47482 | 47482 | 2020-04-10 | McLean | North Dakota | 38055 | 2 | 0 |
50137 | 50137 | 2020-04-11 | McLean | North Dakota | 38055 | 2 | 0 |
52810 | 52810 | 2020-04-12 | McLean | North Dakota | 38055 | 2 | 0 |
55494 | 55494 | 2020-04-13 | McLean | North Dakota | 38055 | 2 | 0 |
58195 | 58195 | 2020-04-14 | McLean | North Dakota | 38055 | 2 | 0 |
34025 | 34025 | 2020-04-05 | McLean | Kentucky | 21149 | 3 | 0 |
36483 | 36483 | 2020-04-06 | McLean | Kentucky | 21149 | 3 | 0 |
38990 | 38990 | 2020-04-07 | McLean | Kentucky | 21149 | 3 | 0 |
41540 | 41540 | 2020-04-08 | McLean | Kentucky | 21149 | 3 | 0 |
60909 | 60909 | 2020-04-15 | McLean | North Dakota | 38055 | 3 | 0 |
63635 | 63635 | 2020-04-16 | McLean | North Dakota | 38055 | 3 | 0 |
66378 | 66378 | 2020-04-17 | McLean | North Dakota | 38055 | 3 | 0 |
69135 | 69135 | 2020-04-18 | McLean | North Dakota | 38055 | 3 | 0 |
71901 | 71901 | 2020-04-19 | McLean | North Dakota | 38055 | 3 | 0 |
74676 | 74676 | 2020-04-20 | McLean | North Dakota | 38055 | 3 | 0 |
77457 | 77457 | 2020-04-21 | McLean | North Dakota | 38055 | 3 | 0 |
80246 | 80246 | 2020-04-22 | McLean | North Dakota | 38055 | 3 | 0 |
83045 | 83045 | 2020-04-23 | McLean | North Dakota | 38055 | 3 | 0 |
85849 | 85849 | 2020-04-24 | McLean | North Dakota | 38055 | 3 | 0 |
88662 | 88662 | 2020-04-25 | McLean | North Dakota | 38055 | 3 | 0 |
91477 | 91477 | 2020-04-26 | McLean | North Dakota | 38055 | 3 | 0 |
94303 | 94303 | 2020-04-27 | McLean | North Dakota | 38055 | 3 | 0 |
97140 | 97140 | 2020-04-28 | McLean | North Dakota | 38055 | 3 | 0 |
99989 | 99989 | 2020-04-29 | McLean | North Dakota | 38055 | 3 | 0 |
102842 | 102842 | 2020-04-30 | McLean | North Dakota | 38055 | 3 | 0 |
105704 | 105704 | 2020-05-01 | McLean | North Dakota | 38055 | 3 | 0 |
5416 | 5416 | 2020-03-20 | McLean | Illinois | 17113 | 4 | 0 |
44116 | 44116 | 2020-04-09 | McLean | Kentucky | 21149 | 4 | 0 |
46724 | 46724 | 2020-04-10 | McLean | Kentucky | 21149 | 4 | 0 |
52030 | 52030 | 2020-04-12 | McLean | Kentucky | 21149 | 5 | 0 |
54711 | 54711 | 2020-04-13 | McLean | Kentucky | 21149 | 5 | 0 |
57409 | 57409 | 2020-04-14 | McLean | Kentucky | 21149 | 5 | 0 |
60118 | 60118 | 2020-04-15 | McLean | Kentucky | 21149 | 5 | 0 |
108571 | 108571 | 2020-05-02 | McLean | North Dakota | 38055 | 5 | 0 |
111445 | 111445 | 2020-05-03 | McLean | North Dakota | 38055 | 5 | 0 |
114326 | 114326 | 2020-05-04 | McLean | North Dakota | 38055 | 5 | 0 |
117206 | 117206 | 2020-05-05 | McLean | North Dakota | 38055 | 5 | 0 |
120167 | 120167 | 2020-05-06 | McLean | North Dakota | 38055 | 5 | 0 |
123143 | 123143 | 2020-05-07 | McLean | North Dakota | 38055 | 5 | 0 |
126126 | 126126 | 2020-05-08 | McLean | North Dakota | 38055 | 5 | 0 |
129115 | 129115 | 2020-05-09 | McLean | North Dakota | 38055 | 5 | 0 |
132104 | 132104 | 2020-05-10 | McLean | North Dakota | 38055 | 5 | 0 |
135095 | 135095 | 2020-05-11 | McLean | North Dakota | 38055 | 5 | 0 |
138085 | 138085 | 2020-05-12 | McLean | North Dakota | 38055 | 5 | 0 |
141081 | 141081 | 2020-05-13 | McLean | North Dakota | 38055 | 5 | 0 |
144076 | 144076 | 2020-05-14 | McLean | North Dakota | 38055 | 5 | 0 |
147077 | 147077 | 2020-05-15 | McLean | North Dakota | 38055 | 5 | 0 |
150084 | 150084 | 2020-05-16 | McLean | North Dakota | 38055 | 5 | 0 |
6351 | 6351 | 2020-03-21 | McLean | Illinois | 17113 | 6 | 0 |
7403 | 7403 | 2020-03-22 | McLean | Illinois | 17113 | 6 | 1 |
49364 | 49364 | 2020-04-11 | McLean | Kentucky | 21149 | 6 | 0 |
62838 | 62838 | 2020-04-16 | McLean | Kentucky | 21149 | 6 | 0 |
65577 | 65577 | 2020-04-17 | McLean | Kentucky | 21149 | 6 | 0 |
68326 | 68326 | 2020-04-18 | McLean | Kentucky | 21149 | 6 | 0 |
153094 | 153094 | 2020-05-17 | McLean | North Dakota | 38055 | 6 | 0 |
156111 | 156111 | 2020-05-18 | McLean | North Dakota | 38055 | 6 | 0 |
8558 | 8558 | 2020-03-23 | McLean | Illinois | 17113 | 7 | 1 |
9822 | 9822 | 2020-03-24 | McLean | Illinois | 17113 | 7 | 1 |
11214 | 11214 | 2020-03-25 | McLean | Illinois | 17113 | 7 | 1 |
12770 | 12770 | 2020-03-26 | McLean | Illinois | 17113 | 7 | 1 |
71089 | 71089 | 2020-04-19 | McLean | Kentucky | 21149 | 7 | 0 |
73861 | 73861 | 2020-04-20 | McLean | Kentucky | 21149 | 7 | 0 |
76642 | 76642 | 2020-04-21 | McLean | Kentucky | 21149 | 7 | 0 |
159131 | 159131 | 2020-05-19 | McLean | North Dakota | 38055 | 7 | 0 |
162158 | 162158 | 2020-05-20 | McLean | North Dakota | 38055 | 7 | 0 |
165187 | 165187 | 2020-05-21 | McLean | North Dakota | 38055 | 7 | 0 |
168223 | 168223 | 2020-05-22 | McLean | North Dakota | 38055 | 7 | 0 |
171262 | 171262 | 2020-05-23 | McLean | North Dakota | 38055 | 7 | 0 |
174304 | 174304 | 2020-05-24 | McLean | North Dakota | 38055 | 7 | 0 |
177348 | 177348 | 2020-05-25 | McLean | North Dakota | 38055 | 7 | 0 |
180391 | 180391 | 2020-05-26 | McLean | North Dakota | 38055 | 7 | 0 |
183439 | 183439 | 2020-05-27 | McLean | North Dakota | 38055 | 7 | 0 |
186496 | 186496 | 2020-05-28 | McLean | North Dakota | 38055 | 7 | 0 |
189556 | 189556 | 2020-05-29 | McLean | North Dakota | 38055 | 7 | 0 |
192620 | 192620 | 2020-05-30 | McLean | North Dakota | 38055 | 7 | 0 |
195690 | 195690 | 2020-05-31 | McLean | North Dakota | 38055 | 7 | 0 |
198763 | 198763 | 2020-06-01 | McLean | North Dakota | 38055 | 7 | 0 |
201838 | 201838 | 2020-06-02 | McLean | North Dakota | 38055 | 7 | 0 |
204915 | 204915 | 2020-06-03 | McLean | North Dakota | 38055 | 7 | 0 |
207996 | 207996 | 2020-06-04 | McLean | North Dakota | 38055 | 7 | 0 |
211078 | 211078 | 2020-06-05 | McLean | North Dakota | 38055 | 7 | 0 |
214163 | 214163 | 2020-06-06 | McLean | North Dakota | 38055 | 7 | 0 |
217253 | 217253 | 2020-06-07 | McLean | North Dakota | 38055 | 7 | 0 |
220345 | 220345 | 2020-06-08 | McLean | North Dakota | 38055 | 7 | 0 |
79427 | 79427 | 2020-04-22 | McLean | Kentucky | 21149 | 8 | 0 |
82224 | 82224 | 2020-04-23 | McLean | Kentucky | 21149 | 8 | 0 |
223440 | 223440 | 2020-06-09 | McLean | North Dakota | 38055 | 8 | 0 |
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);