ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Durham" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387852 | 387852 | 2020-07-31 | Durham | North Carolina | 37063 | 5789 | 77 |
384635 | 384635 | 2020-07-30 | Durham | North Carolina | 37063 | 5719 | 77 |
381417 | 381417 | 2020-07-29 | Durham | North Carolina | 37063 | 5659 | 77 |
378200 | 378200 | 2020-07-28 | Durham | North Carolina | 37063 | 5567 | 76 |
374984 | 374984 | 2020-07-27 | Durham | North Carolina | 37063 | 5566 | 76 |
371772 | 371772 | 2020-07-26 | Durham | North Carolina | 37063 | 5514 | 76 |
368560 | 368560 | 2020-07-25 | Durham | North Carolina | 37063 | 5469 | 76 |
365351 | 365351 | 2020-07-24 | Durham | North Carolina | 37063 | 5413 | 76 |
362145 | 362145 | 2020-07-23 | Durham | North Carolina | 37063 | 5360 | 76 |
358939 | 358939 | 2020-07-22 | Durham | North Carolina | 37063 | 5269 | 74 |
355735 | 355735 | 2020-07-21 | Durham | North Carolina | 37063 | 5219 | 73 |
352532 | 352532 | 2020-07-20 | Durham | North Carolina | 37063 | 5133 | 73 |
349329 | 349329 | 2020-07-19 | Durham | North Carolina | 37063 | 5072 | 73 |
346128 | 346128 | 2020-07-18 | Durham | North Carolina | 37063 | 5011 | 72 |
342929 | 342929 | 2020-07-17 | Durham | North Carolina | 37063 | 4944 | 72 |
339731 | 339731 | 2020-07-16 | Durham | North Carolina | 37063 | 4880 | 72 |
336535 | 336535 | 2020-07-15 | Durham | North Carolina | 37063 | 4788 | 72 |
333341 | 333341 | 2020-07-14 | Durham | North Carolina | 37063 | 4723 | 72 |
330151 | 330151 | 2020-07-13 | Durham | North Carolina | 37063 | 4652 | 72 |
326964 | 326964 | 2020-07-12 | Durham | North Carolina | 37063 | 4563 | 70 |
323780 | 323780 | 2020-07-11 | Durham | North Carolina | 37063 | 4494 | 68 |
320600 | 320600 | 2020-07-10 | Durham | North Carolina | 37063 | 4421 | 68 |
317423 | 317423 | 2020-07-09 | Durham | North Carolina | 37063 | 4277 | 67 |
314249 | 314249 | 2020-07-08 | Durham | North Carolina | 37063 | 4277 | 67 |
311078 | 311078 | 2020-07-07 | Durham | North Carolina | 37063 | 4208 | 67 |
307910 | 307910 | 2020-07-06 | Durham | North Carolina | 37063 | 4176 | 67 |
304743 | 304743 | 2020-07-05 | Durham | North Carolina | 37063 | 4113 | 67 |
301580 | 301580 | 2020-07-04 | Durham | North Carolina | 37063 | 4064 | 67 |
298417 | 298417 | 2020-07-03 | Durham | North Carolina | 37063 | 4015 | 66 |
295257 | 295257 | 2020-07-02 | Durham | North Carolina | 37063 | 3976 | 65 |
292102 | 292102 | 2020-07-01 | Durham | North Carolina | 37063 | 3876 | 65 |
288950 | 288950 | 2020-06-30 | Durham | North Carolina | 37063 | 3807 | 63 |
285800 | 285800 | 2020-06-29 | Durham | North Carolina | 37063 | 3679 | 63 |
282655 | 282655 | 2020-06-28 | Durham | North Carolina | 37063 | 3571 | 63 |
279509 | 279509 | 2020-06-27 | Durham | North Carolina | 37063 | 3532 | 63 |
276361 | 276361 | 2020-06-26 | Durham | North Carolina | 37063 | 3532 | 63 |
273215 | 273215 | 2020-06-25 | Durham | North Carolina | 37063 | 3479 | 63 |
270076 | 270076 | 2020-06-24 | Durham | North Carolina | 37063 | 3402 | 62 |
266942 | 266942 | 2020-06-23 | Durham | North Carolina | 37063 | 3340 | 62 |
263814 | 263814 | 2020-06-22 | Durham | North Carolina | 37063 | 3212 | 62 |
260686 | 260686 | 2020-06-21 | Durham | North Carolina | 37063 | 3196 | 62 |
257559 | 257559 | 2020-06-20 | Durham | North Carolina | 37063 | 3151 | 62 |
254436 | 254436 | 2020-06-19 | Durham | North Carolina | 37063 | 3063 | 62 |
251321 | 251321 | 2020-06-18 | Durham | North Carolina | 37063 | 3004 | 62 |
248206 | 248206 | 2020-06-17 | Durham | North Carolina | 37063 | 2945 | 59 |
245093 | 245093 | 2020-06-16 | Durham | North Carolina | 37063 | 2800 | 58 |
241981 | 241981 | 2020-06-15 | Durham | North Carolina | 37063 | 2800 | 58 |
238872 | 238872 | 2020-06-14 | Durham | North Carolina | 37063 | 2695 | 58 |
235764 | 235764 | 2020-06-13 | Durham | North Carolina | 37063 | 2647 | 58 |
232659 | 232659 | 2020-06-12 | Durham | North Carolina | 37063 | 2563 | 57 |
229554 | 229554 | 2020-06-11 | Durham | North Carolina | 37063 | 2473 | 57 |
226450 | 226450 | 2020-06-10 | Durham | North Carolina | 37063 | 2307 | 53 |
223350 | 223350 | 2020-06-09 | Durham | North Carolina | 37063 | 2227 | 51 |
220256 | 220256 | 2020-06-08 | Durham | North Carolina | 37063 | 2180 | 49 |
217164 | 217164 | 2020-06-07 | Durham | North Carolina | 37063 | 2114 | 49 |
214074 | 214074 | 2020-06-06 | Durham | North Carolina | 37063 | 2067 | 49 |
210990 | 210990 | 2020-06-05 | Durham | North Carolina | 37063 | 1921 | 49 |
207908 | 207908 | 2020-06-04 | Durham | North Carolina | 37063 | 1921 | 49 |
204827 | 204827 | 2020-06-03 | Durham | North Carolina | 37063 | 1774 | 49 |
201750 | 201750 | 2020-06-02 | Durham | North Carolina | 37063 | 1706 | 47 |
198676 | 198676 | 2020-06-01 | Durham | North Carolina | 37063 | 1660 | 47 |
195603 | 195603 | 2020-05-31 | Durham | North Carolina | 37063 | 1619 | 47 |
192533 | 192533 | 2020-05-30 | Durham | North Carolina | 37063 | 1552 | 47 |
189469 | 189469 | 2020-05-29 | Durham | North Carolina | 37063 | 1525 | 47 |
186409 | 186409 | 2020-05-28 | Durham | North Carolina | 37063 | 1411 | 46 |
183352 | 183352 | 2020-05-27 | Durham | North Carolina | 37063 | 1359 | 45 |
180304 | 180304 | 2020-05-26 | Durham | North Carolina | 37063 | 1333 | 45 |
177261 | 177261 | 2020-05-25 | Durham | North Carolina | 37063 | 1312 | 45 |
174217 | 174217 | 2020-05-24 | Durham | North Carolina | 37063 | 1262 | 44 |
171175 | 171175 | 2020-05-23 | Durham | North Carolina | 37063 | 1230 | 43 |
168136 | 168136 | 2020-05-22 | Durham | North Carolina | 37063 | 1162 | 43 |
165101 | 165101 | 2020-05-21 | Durham | North Carolina | 37063 | 1131 | 43 |
162072 | 162072 | 2020-05-20 | Durham | North Carolina | 37063 | 1131 | 43 |
159045 | 159045 | 2020-05-19 | Durham | North Carolina | 37063 | 1053 | 39 |
156026 | 156026 | 2020-05-18 | Durham | North Carolina | 37063 | 1040 | 39 |
153009 | 153009 | 2020-05-17 | Durham | North Carolina | 37063 | 996 | 39 |
149999 | 149999 | 2020-05-16 | Durham | North Carolina | 37063 | 980 | 37 |
146992 | 146992 | 2020-05-15 | Durham | North Carolina | 37063 | 938 | 37 |
143991 | 143991 | 2020-05-14 | Durham | North Carolina | 37063 | 932 | 37 |
140996 | 140996 | 2020-05-13 | Durham | North Carolina | 37063 | 932 | 37 |
138000 | 138000 | 2020-05-12 | Durham | North Carolina | 37063 | 914 | 36 |
135010 | 135010 | 2020-05-11 | Durham | North Carolina | 37063 | 897 | 35 |
132019 | 132019 | 2020-05-10 | Durham | North Carolina | 37063 | 886 | 34 |
129030 | 129030 | 2020-05-09 | Durham | North Carolina | 37063 | 876 | 32 |
126041 | 126041 | 2020-05-08 | Durham | North Carolina | 37063 | 841 | 31 |
123058 | 123058 | 2020-05-07 | Durham | North Carolina | 37063 | 841 | 31 |
120083 | 120083 | 2020-05-06 | Durham | North Carolina | 37063 | 818 | 30 |
117122 | 117122 | 2020-05-05 | Durham | North Carolina | 37063 | 800 | 28 |
114242 | 114242 | 2020-05-04 | Durham | North Carolina | 37063 | 790 | 26 |
111361 | 111361 | 2020-05-03 | Durham | North Carolina | 37063 | 767 | 24 |
108488 | 108488 | 2020-05-02 | Durham | North Carolina | 37063 | 755 | 23 |
105621 | 105621 | 2020-05-01 | Durham | North Carolina | 37063 | 736 | 21 |
102759 | 102759 | 2020-04-30 | Durham | North Carolina | 37063 | 728 | 18 |
99906 | 99906 | 2020-04-29 | Durham | North Carolina | 37063 | 708 | 17 |
97059 | 97059 | 2020-04-28 | Durham | North Carolina | 37063 | 702 | 16 |
94223 | 94223 | 2020-04-27 | Durham | North Carolina | 37063 | 539 | 13 |
91397 | 91397 | 2020-04-26 | Durham | North Carolina | 37063 | 535 | 10 |
88582 | 88582 | 2020-04-25 | Durham | North Carolina | 37063 | 517 | 9 |
85770 | 85770 | 2020-04-24 | Durham | North Carolina | 37063 | 494 | 8 |
82966 | 82966 | 2020-04-23 | Durham | North Carolina | 37063 | 459 | 7 |
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);