ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

172 rows where fips = 6037 sorted by date descending

View and edit SQL

state

fips

  • 6037 · 172

county

Link rowid date ▲ county state fips cases deaths
334579 2020-07-15 Los Angeles California 6037 143009 3936
331388 2020-07-14 Los Angeles California 6037 140307 3894
328204 2020-07-13 Los Angeles California 6037 136129 3822
325020 2020-07-12 Los Angeles California 6037 133549 3809
321841 2020-07-11 Los Angeles California 6037 130242 3793
318664 2020-07-10 Los Angeles California 6037 127358 3738
315493 2020-07-09 Los Angeles California 6037 124738 3689
312320 2020-07-08 Los Angeles California 6037 123004 3642
309152 2020-07-07 Los Angeles California 6037 120539 3579
305986 2020-07-06 Los Angeles California 6037 116570 3534
302824 2020-07-05 Los Angeles California 6037 114993 3487
299662 2020-07-04 Los Angeles California 6037 113497 3454
296502 2020-07-03 Los Angeles California 6037 110310 3454
293348 2020-07-02 Los Angeles California 6037 107667 3454
290196 2020-07-01 Los Angeles California 6037 105507 3402
287047 2020-06-30 Los Angeles California 6037 103529 3369
283902 2020-06-29 Los Angeles California 6037 100772 3326
280757 2020-06-28 Los Angeles California 6037 97894 3305
277611 2020-06-27 Los Angeles California 6037 95371 3285
274465 2020-06-26 Los Angeles California 6037 93232 3267
271327 2020-06-25 Los Angeles California 6037 91467 3246
268194 2020-06-24 Los Angeles California 6037 89490 3205
265066 2020-06-23 Los Angeles California 6037 88262 3171
261939 2020-06-22 Los Angeles California 6037 85942 3137
258814 2020-06-21 Los Angeles California 6037 83397 3120
255689 2020-06-20 Los Angeles California 6037 81636 3110
252572 2020-06-19 Los Angeles California 6037 79609 3063
249459 2020-06-18 Los Angeles California 6037 78227 3027
246349 2020-06-17 Los Angeles California 6037 77189 2991
243238 2020-06-16 Los Angeles California 6037 75084 2959
240129 2020-06-15 Los Angeles California 6037 73791 2926
237023 2020-06-14 Los Angeles California 6037 73018 2907
233918 2020-06-13 Los Angeles California 6037 72023 2890
230814 2020-06-12 Los Angeles California 6037 70476 2832
227712 2020-06-11 Los Angeles California 6037 68875 2813
224612 2020-06-10 Los Angeles California 6037 67064 2768
221518 2020-06-09 Los Angeles California 6037 65822 2707
218425 2020-06-08 Los Angeles California 6037 64644 2655
215336 2020-06-07 Los Angeles California 6037 63844 2645
212251 2020-06-06 Los Angeles California 6037 62338 2620
209168 2020-06-05 Los Angeles California 6037 61045 2565
206089 2020-06-04 Los Angeles California 6037 59650 2531
203012 2020-06-03 Los Angeles California 6037 58234 2489
199939 2020-06-02 Los Angeles California 6037 57118 2443
196869 2020-06-01 Los Angeles California 6037 55968 2384
193802 2020-05-31 Los Angeles California 6037 54996 2362
190738 2020-05-30 Los Angeles California 6037 53651 2338
187676 2020-05-29 Los Angeles California 6037 51562 2290
184623 2020-05-28 Los Angeles California 6037 49774 2241
181572 2020-05-27 Los Angeles California 6037 48700 2195
178531 2020-05-26 Los Angeles California 6037 47822 2143
175490 2020-05-25 Los Angeles California 6037 46018 2116
172449 2020-05-24 Los Angeles California 6037 44988 2104
169411 2020-05-23 Los Angeles California 6037 44055 2090
166377 2020-05-22 Los Angeles California 6037 43052 2049
163348 2020-05-21 Los Angeles California 6037 42037 2016
160323 2020-05-20 Los Angeles California 6037 40857 1970
157300 2020-05-19 Los Angeles California 6037 39573 1913
154287 2020-05-18 Los Angeles California 6037 38451 1839
151278 2020-05-17 Los Angeles California 6037 37974 1821
148272 2020-05-16 Los Angeles California 6037 37303 1793
145271 2020-05-15 Los Angeles California 6037 36259 1755
142275 2020-05-14 Los Angeles California 6037 35329 1659
139282 2020-05-13 Los Angeles California 6037 34428 1659
136294 2020-05-12 Los Angeles California 6037 33180 1613
133307 2020-05-11 Los Angeles California 6037 32258 1569
130320 2020-05-10 Los Angeles California 6037 31677 1530
127333 2020-05-09 Los Angeles California 6037 31197 1512
124351 2020-05-08 Los Angeles California 6037 30296 1468
121374 2020-05-07 Los Angeles California 6037 29427 1418
118411 2020-05-06 Los Angeles California 6037 28644 1367
115456 2020-05-05 Los Angeles California 6037 27815 1313
112577 2020-05-04 Los Angeles California 6037 26217 1256
109706 2020-05-03 Los Angeles California 6037 25662 1229
106841 2020-05-02 Los Angeles California 6037 24894 1209
103980 2020-05-01 Los Angeles California 6037 24215 1172
101129 2020-04-30 Los Angeles California 6037 23182 1111
98283 2020-04-29 Los Angeles California 6037 22485 1056
95442 2020-04-28 Los Angeles California 6037 20976 1000
92614 2020-04-27 Los Angeles California 6037 20417 942
89799 2020-04-26 Los Angeles California 6037 19528 913
86985 2020-04-25 Los Angeles California 6037 19107 895
84180 2020-04-24 Los Angeles California 6037 18545 850
81383 2020-04-23 Los Angeles California 6037 17508 797
78592 2020-04-22 Los Angeles California 6037 16435 729
75811 2020-04-21 Los Angeles California 6037 15140 663
73038 2020-04-20 Los Angeles California 6037 13816 617
70272 2020-04-19 Los Angeles California 6037 12341 600
67513 2020-04-18 Los Angeles California 6037 12021 576
64768 2020-04-17 Los Angeles California 6037 11391 495
62038 2020-04-16 Los Angeles California 6037 10854 455
59322 2020-04-15 Los Angeles California 6037 10496 402
56617 2020-04-14 Los Angeles California 6037 10047 360
53928 2020-04-13 Los Angeles California 6037 9420 320
51252 2020-04-12 Los Angeles California 6037 9192 296
48593 2020-04-11 Los Angeles California 6037 8873 265
45966 2020-04-10 Los Angeles California 6037 8430 241
43369 2020-04-09 Los Angeles California 6037 7955 223
40800 2020-04-08 Los Angeles California 6037 7530 198
38259 2020-04-07 Los Angeles California 6037 6910 169

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1635.796ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette