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 deaths
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 ▼ |
---|---|---|---|---|---|---|---|
5416 | 5416 | 2020-03-20 | McLean | Illinois | 17113 | 4 | 0 |
6351 | 6351 | 2020-03-21 | McLean | Illinois | 17113 | 6 | 0 |
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 |
34025 | 34025 | 2020-04-05 | McLean | Kentucky | 21149 | 3 | 0 |
34742 | 34742 | 2020-04-05 | McLean | North Dakota | 38055 | 2 | 0 |
36483 | 36483 | 2020-04-06 | McLean | Kentucky | 21149 | 3 | 0 |
37211 | 37211 | 2020-04-06 | McLean | North Dakota | 38055 | 2 | 0 |
38990 | 38990 | 2020-04-07 | McLean | Kentucky | 21149 | 3 | 0 |
39728 | 39728 | 2020-04-07 | McLean | North Dakota | 38055 | 2 | 0 |
41540 | 41540 | 2020-04-08 | McLean | Kentucky | 21149 | 3 | 0 |
42285 | 42285 | 2020-04-08 | McLean | North Dakota | 38055 | 2 | 0 |
44116 | 44116 | 2020-04-09 | McLean | Kentucky | 21149 | 4 | 0 |
44869 | 44869 | 2020-04-09 | McLean | North Dakota | 38055 | 2 | 0 |
46724 | 46724 | 2020-04-10 | McLean | Kentucky | 21149 | 4 | 0 |
47482 | 47482 | 2020-04-10 | McLean | North Dakota | 38055 | 2 | 0 |
49364 | 49364 | 2020-04-11 | McLean | Kentucky | 21149 | 6 | 0 |
50137 | 50137 | 2020-04-11 | McLean | North Dakota | 38055 | 2 | 0 |
52030 | 52030 | 2020-04-12 | McLean | Kentucky | 21149 | 5 | 0 |
52810 | 52810 | 2020-04-12 | McLean | North Dakota | 38055 | 2 | 0 |
54711 | 54711 | 2020-04-13 | McLean | Kentucky | 21149 | 5 | 0 |
55494 | 55494 | 2020-04-13 | McLean | North Dakota | 38055 | 2 | 0 |
57409 | 57409 | 2020-04-14 | McLean | Kentucky | 21149 | 5 | 0 |
58195 | 58195 | 2020-04-14 | McLean | North Dakota | 38055 | 2 | 0 |
60118 | 60118 | 2020-04-15 | McLean | Kentucky | 21149 | 5 | 0 |
60909 | 60909 | 2020-04-15 | McLean | North Dakota | 38055 | 3 | 0 |
62838 | 62838 | 2020-04-16 | McLean | Kentucky | 21149 | 6 | 0 |
63635 | 63635 | 2020-04-16 | McLean | North Dakota | 38055 | 3 | 0 |
65577 | 65577 | 2020-04-17 | McLean | Kentucky | 21149 | 6 | 0 |
66378 | 66378 | 2020-04-17 | McLean | North Dakota | 38055 | 3 | 0 |
68326 | 68326 | 2020-04-18 | McLean | Kentucky | 21149 | 6 | 0 |
69135 | 69135 | 2020-04-18 | McLean | North Dakota | 38055 | 3 | 0 |
71089 | 71089 | 2020-04-19 | McLean | Kentucky | 21149 | 7 | 0 |
71901 | 71901 | 2020-04-19 | McLean | North Dakota | 38055 | 3 | 0 |
73861 | 73861 | 2020-04-20 | McLean | Kentucky | 21149 | 7 | 0 |
74676 | 74676 | 2020-04-20 | McLean | North Dakota | 38055 | 3 | 0 |
76642 | 76642 | 2020-04-21 | McLean | Kentucky | 21149 | 7 | 0 |
77457 | 77457 | 2020-04-21 | McLean | North Dakota | 38055 | 3 | 0 |
79427 | 79427 | 2020-04-22 | McLean | Kentucky | 21149 | 8 | 0 |
80246 | 80246 | 2020-04-22 | McLean | North Dakota | 38055 | 3 | 0 |
82224 | 82224 | 2020-04-23 | McLean | Kentucky | 21149 | 8 | 0 |
83045 | 83045 | 2020-04-23 | McLean | North Dakota | 38055 | 3 | 0 |
85027 | 85027 | 2020-04-24 | McLean | Kentucky | 21149 | 9 | 0 |
85849 | 85849 | 2020-04-24 | McLean | North Dakota | 38055 | 3 | 0 |
87836 | 87836 | 2020-04-25 | McLean | Kentucky | 21149 | 10 | 0 |
88662 | 88662 | 2020-04-25 | McLean | North Dakota | 38055 | 3 | 0 |
90652 | 90652 | 2020-04-26 | McLean | Kentucky | 21149 | 11 | 0 |
91477 | 91477 | 2020-04-26 | McLean | North Dakota | 38055 | 3 | 0 |
93473 | 93473 | 2020-04-27 | McLean | Kentucky | 21149 | 11 | 0 |
94303 | 94303 | 2020-04-27 | McLean | North Dakota | 38055 | 3 | 0 |
96306 | 96306 | 2020-04-28 | McLean | Kentucky | 21149 | 11 | 0 |
97140 | 97140 | 2020-04-28 | McLean | North Dakota | 38055 | 3 | 0 |
99152 | 99152 | 2020-04-29 | McLean | Kentucky | 21149 | 12 | 0 |
99989 | 99989 | 2020-04-29 | McLean | North Dakota | 38055 | 3 | 0 |
102004 | 102004 | 2020-04-30 | McLean | Kentucky | 21149 | 14 | 0 |
102842 | 102842 | 2020-04-30 | McLean | North Dakota | 38055 | 3 | 0 |
104865 | 104865 | 2020-05-01 | McLean | Kentucky | 21149 | 15 | 0 |
105704 | 105704 | 2020-05-01 | McLean | North Dakota | 38055 | 3 | 0 |
107730 | 107730 | 2020-05-02 | McLean | Kentucky | 21149 | 14 | 0 |
108571 | 108571 | 2020-05-02 | McLean | North Dakota | 38055 | 5 | 0 |
110601 | 110601 | 2020-05-03 | McLean | Kentucky | 21149 | 15 | 0 |
111445 | 111445 | 2020-05-03 | McLean | North Dakota | 38055 | 5 | 0 |
113478 | 113478 | 2020-05-04 | McLean | Kentucky | 21149 | 16 | 0 |
114326 | 114326 | 2020-05-04 | McLean | North Dakota | 38055 | 5 | 0 |
116360 | 116360 | 2020-05-05 | McLean | Kentucky | 21149 | 16 | 0 |
117206 | 117206 | 2020-05-05 | McLean | North Dakota | 38055 | 5 | 0 |
119321 | 119321 | 2020-05-06 | McLean | Kentucky | 21149 | 16 | 0 |
120167 | 120167 | 2020-05-06 | McLean | North Dakota | 38055 | 5 | 0 |
122292 | 122292 | 2020-05-07 | McLean | Kentucky | 21149 | 16 | 0 |
123143 | 123143 | 2020-05-07 | McLean | North Dakota | 38055 | 5 | 0 |
125274 | 125274 | 2020-05-08 | McLean | Kentucky | 21149 | 18 | 0 |
126126 | 126126 | 2020-05-08 | McLean | North Dakota | 38055 | 5 | 0 |
128262 | 128262 | 2020-05-09 | McLean | Kentucky | 21149 | 18 | 0 |
129115 | 129115 | 2020-05-09 | McLean | North Dakota | 38055 | 5 | 0 |
131252 | 131252 | 2020-05-10 | McLean | Kentucky | 21149 | 18 | 0 |
132104 | 132104 | 2020-05-10 | McLean | North Dakota | 38055 | 5 | 0 |
134243 | 134243 | 2020-05-11 | McLean | Kentucky | 21149 | 18 | 0 |
135095 | 135095 | 2020-05-11 | McLean | North Dakota | 38055 | 5 | 0 |
137233 | 137233 | 2020-05-12 | McLean | Kentucky | 21149 | 18 | 0 |
138085 | 138085 | 2020-05-12 | McLean | North Dakota | 38055 | 5 | 0 |
140226 | 140226 | 2020-05-13 | McLean | Kentucky | 21149 | 19 | 0 |
141081 | 141081 | 2020-05-13 | McLean | North Dakota | 38055 | 5 | 0 |
143222 | 143222 | 2020-05-14 | McLean | Kentucky | 21149 | 19 | 0 |
144076 | 144076 | 2020-05-14 | McLean | North Dakota | 38055 | 5 | 0 |
146222 | 146222 | 2020-05-15 | McLean | Kentucky | 21149 | 19 | 0 |
147077 | 147077 | 2020-05-15 | McLean | North Dakota | 38055 | 5 | 0 |
149227 | 149227 | 2020-05-16 | McLean | Kentucky | 21149 | 19 | 0 |
150084 | 150084 | 2020-05-16 | McLean | North Dakota | 38055 | 5 | 0 |
152238 | 152238 | 2020-05-17 | McLean | Kentucky | 21149 | 19 | 0 |
153094 | 153094 | 2020-05-17 | McLean | North Dakota | 38055 | 6 | 0 |
155252 | 155252 | 2020-05-18 | McLean | Kentucky | 21149 | 19 | 0 |
156111 | 156111 | 2020-05-18 | McLean | North Dakota | 38055 | 6 | 0 |
158269 | 158269 | 2020-05-19 | McLean | Kentucky | 21149 | 20 | 0 |
159131 | 159131 | 2020-05-19 | McLean | North Dakota | 38055 | 7 | 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);