ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Washington" and fips = 24043 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
6504 | 6504 | 2020-03-21 | Washington | Maryland | 24043 | 1 | 0 |
7581 | 7581 | 2020-03-22 | Washington | Maryland | 24043 | 1 | 0 |
8753 | 8753 | 2020-03-23 | Washington | Maryland | 24043 | 2 | 0 |
10042 | 10042 | 2020-03-24 | Washington | Maryland | 24043 | 2 | 0 |
11453 | 11453 | 2020-03-25 | Washington | Maryland | 24043 | 2 | 0 |
13034 | 13034 | 2020-03-26 | Washington | Maryland | 24043 | 2 | 0 |
14742 | 14742 | 2020-03-27 | Washington | Maryland | 24043 | 5 | 0 |
16562 | 16562 | 2020-03-28 | Washington | Maryland | 24043 | 6 | 0 |
18477 | 18477 | 2020-03-29 | Washington | Maryland | 24043 | 6 | 0 |
20493 | 20493 | 2020-03-30 | Washington | Maryland | 24043 | 7 | 0 |
22602 | 22602 | 2020-03-31 | Washington | Maryland | 24043 | 11 | 0 |
24781 | 24781 | 2020-04-01 | Washington | Maryland | 24043 | 15 | 0 |
27033 | 27033 | 2020-04-02 | Washington | Maryland | 24043 | 17 | 0 |
29351 | 29351 | 2020-04-03 | Washington | Maryland | 24043 | 27 | 0 |
31729 | 31729 | 2020-04-04 | Washington | Maryland | 24043 | 29 | 0 |
34154 | 34154 | 2020-04-05 | Washington | Maryland | 24043 | 34 | 0 |
36613 | 36613 | 2020-04-06 | Washington | Maryland | 24043 | 37 | 0 |
39121 | 39121 | 2020-04-07 | Washington | Maryland | 24043 | 44 | 0 |
41673 | 41673 | 2020-04-08 | Washington | Maryland | 24043 | 57 | 0 |
44249 | 44249 | 2020-04-09 | Washington | Maryland | 24043 | 60 | 0 |
46857 | 46857 | 2020-04-10 | Washington | Maryland | 24043 | 66 | 0 |
49499 | 49499 | 2020-04-11 | Washington | Maryland | 24043 | 72 | 1 |
52169 | 52169 | 2020-04-12 | Washington | Maryland | 24043 | 75 | 1 |
54850 | 54850 | 2020-04-13 | Washington | Maryland | 24043 | 93 | 1 |
57548 | 57548 | 2020-04-14 | Washington | Maryland | 24043 | 96 | 1 |
60257 | 60257 | 2020-04-15 | Washington | Maryland | 24043 | 106 | 0 |
62978 | 62978 | 2020-04-16 | Washington | Maryland | 24043 | 109 | 1 |
65716 | 65716 | 2020-04-17 | Washington | Maryland | 24043 | 116 | 1 |
68466 | 68466 | 2020-04-18 | Washington | Maryland | 24043 | 116 | 3 |
71230 | 71230 | 2020-04-19 | Washington | Maryland | 24043 | 117 | 3 |
74002 | 74002 | 2020-04-20 | Washington | Maryland | 24043 | 123 | 3 |
76782 | 76782 | 2020-04-21 | Washington | Maryland | 24043 | 126 | 3 |
79568 | 79568 | 2020-04-22 | Washington | Maryland | 24043 | 127 | 3 |
82363 | 82363 | 2020-04-23 | Washington | Maryland | 24043 | 139 | 3 |
85167 | 85167 | 2020-04-24 | Washington | Maryland | 24043 | 143 | 3 |
87977 | 87977 | 2020-04-25 | Washington | Maryland | 24043 | 154 | 3 |
90793 | 90793 | 2020-04-26 | Washington | Maryland | 24043 | 173 | 3 |
93614 | 93614 | 2020-04-27 | Washington | Maryland | 24043 | 181 | 3 |
96449 | 96449 | 2020-04-28 | Washington | Maryland | 24043 | 187 | 3 |
99295 | 99295 | 2020-04-29 | Washington | Maryland | 24043 | 197 | 3 |
102147 | 102147 | 2020-04-30 | Washington | Maryland | 24043 | 206 | 4 |
105007 | 105007 | 2020-05-01 | Washington | Maryland | 24043 | 216 | 4 |
107871 | 107871 | 2020-05-02 | Washington | Maryland | 24043 | 225 | 6 |
110743 | 110743 | 2020-05-03 | Washington | Maryland | 24043 | 232 | 6 |
113621 | 113621 | 2020-05-04 | Washington | Maryland | 24043 | 237 | 6 |
116502 | 116502 | 2020-05-05 | Washington | Maryland | 24043 | 238 | 6 |
119463 | 119463 | 2020-05-06 | Washington | Maryland | 24043 | 251 | 7 |
122435 | 122435 | 2020-05-07 | Washington | Maryland | 24043 | 260 | 7 |
125417 | 125417 | 2020-05-08 | Washington | Maryland | 24043 | 259 | 7 |
128404 | 128404 | 2020-05-09 | Washington | Maryland | 24043 | 265 | 8 |
131394 | 131394 | 2020-05-10 | Washington | Maryland | 24043 | 276 | 9 |
134385 | 134385 | 2020-05-11 | Washington | Maryland | 24043 | 283 | 9 |
137375 | 137375 | 2020-05-12 | Washington | Maryland | 24043 | 284 | 9 |
140369 | 140369 | 2020-05-13 | Washington | Maryland | 24043 | 287 | 9 |
143364 | 143364 | 2020-05-14 | Washington | Maryland | 24043 | 305 | 9 |
146364 | 146364 | 2020-05-15 | Washington | Maryland | 24043 | 320 | 9 |
149369 | 149369 | 2020-05-16 | Washington | Maryland | 24043 | 332 | 9 |
152380 | 152380 | 2020-05-17 | Washington | Maryland | 24043 | 338 | 8 |
155394 | 155394 | 2020-05-18 | Washington | Maryland | 24043 | 343 | 8 |
158412 | 158412 | 2020-05-19 | Washington | Maryland | 24043 | 352 | 8 |
161438 | 161438 | 2020-05-20 | Washington | Maryland | 24043 | 364 | 9 |
164467 | 164467 | 2020-05-21 | Washington | Maryland | 24043 | 377 | 10 |
167503 | 167503 | 2020-05-22 | Washington | Maryland | 24043 | 389 | 10 |
170540 | 170540 | 2020-05-23 | Washington | Maryland | 24043 | 398 | 10 |
173582 | 173582 | 2020-05-24 | Washington | Maryland | 24043 | 408 | 11 |
176625 | 176625 | 2020-05-25 | Washington | Maryland | 24043 | 413 | 11 |
179669 | 179669 | 2020-05-26 | Washington | Maryland | 24043 | 413 | 12 |
182715 | 182715 | 2020-05-27 | Washington | Maryland | 24043 | 418 | 12 |
185770 | 185770 | 2020-05-28 | Washington | Maryland | 24043 | 423 | 12 |
188828 | 188828 | 2020-05-29 | Washington | Maryland | 24043 | 441 | 13 |
191892 | 191892 | 2020-05-30 | Washington | Maryland | 24043 | 456 | 13 |
194960 | 194960 | 2020-05-31 | Washington | Maryland | 24043 | 469 | 14 |
198031 | 198031 | 2020-06-01 | Washington | Maryland | 24043 | 472 | 14 |
201103 | 201103 | 2020-06-02 | Washington | Maryland | 24043 | 480 | 15 |
204180 | 204180 | 2020-06-03 | Washington | Maryland | 24043 | 486 | 16 |
207261 | 207261 | 2020-06-04 | Washington | Maryland | 24043 | 516 | 16 |
210342 | 210342 | 2020-06-05 | Washington | Maryland | 24043 | 529 | 16 |
213426 | 213426 | 2020-06-06 | Washington | Maryland | 24043 | 545 | 16 |
216514 | 216514 | 2020-06-07 | Washington | Maryland | 24043 | 548 | 16 |
219606 | 219606 | 2020-06-08 | Washington | Maryland | 24043 | 551 | 16 |
222701 | 222701 | 2020-06-09 | Washington | Maryland | 24043 | 545 | 17 |
225797 | 225797 | 2020-06-10 | Washington | Maryland | 24043 | 551 | 17 |
228899 | 228899 | 2020-06-11 | Washington | Maryland | 24043 | 560 | 20 |
232003 | 232003 | 2020-06-12 | Washington | Maryland | 24043 | 568 | 21 |
235108 | 235108 | 2020-06-13 | Washington | Maryland | 24043 | 570 | 22 |
238215 | 238215 | 2020-06-14 | Washington | Maryland | 24043 | 571 | 22 |
241324 | 241324 | 2020-06-15 | Washington | Maryland | 24043 | 579 | 22 |
244435 | 244435 | 2020-06-16 | Washington | Maryland | 24043 | 579 | 22 |
247548 | 247548 | 2020-06-17 | Washington | Maryland | 24043 | 593 | 22 |
250660 | 250660 | 2020-06-18 | Washington | Maryland | 24043 | 595 | 24 |
253775 | 253775 | 2020-06-19 | Washington | Maryland | 24043 | 601 | 25 |
256895 | 256895 | 2020-06-20 | Washington | Maryland | 24043 | 602 | 25 |
260021 | 260021 | 2020-06-21 | Washington | Maryland | 24043 | 603 | 25 |
263150 | 263150 | 2020-06-22 | Washington | Maryland | 24043 | 611 | 25 |
266276 | 266276 | 2020-06-23 | Washington | Maryland | 24043 | 616 | 25 |
269409 | 269409 | 2020-06-24 | Washington | Maryland | 24043 | 634 | 26 |
272546 | 272546 | 2020-06-25 | Washington | Maryland | 24043 | 653 | 26 |
275689 | 275689 | 2020-06-26 | Washington | Maryland | 24043 | 663 | 26 |
278837 | 278837 | 2020-06-27 | Washington | Maryland | 24043 | 684 | 26 |
281985 | 281985 | 2020-06-28 | Washington | Maryland | 24043 | 694 | 26 |
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);