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

162 rows where fips = 25025 sorted by date descending

View and edit SQL

state

fips

  • 25025 · 162

county

Link rowid date ▲ county state fips cases deaths
317672 2020-07-11 Suffolk Massachusetts 25025 20272 1018
314574 2020-07-10 Suffolk Massachusetts 25025 20228 1016
311480 2020-07-09 Suffolk Massachusetts 25025 20172 1013
308386 2020-07-08 Suffolk Massachusetts 25025 20120 1012
305296 2020-07-07 Suffolk Massachusetts 25025 20048 1008
302208 2020-07-06 Suffolk Massachusetts 25025 20014 1008
299121 2020-07-05 Suffolk Massachusetts 25025 19985 1007
296037 2020-07-04 Suffolk Massachusetts 25025 19972 1008
292955 2020-07-03 Suffolk Massachusetts 25025 19936 1009
289877 2020-07-02 Suffolk Massachusetts 25025 19892 1008
286803 2020-07-01 Suffolk Massachusetts 25025 19853 1004
283732 2020-06-30 Suffolk Massachusetts 25025 19819 1002
280661 2020-06-29 Suffolk Massachusetts 25025 19795 1007
277595 2020-06-28 Suffolk Massachusetts 25025 19795 1004
274526 2020-06-27 Suffolk Massachusetts 25025 19764 1004
271458 2020-06-26 Suffolk Massachusetts 25025 19707 997
268395 2020-06-25 Suffolk Massachusetts 25025 19664 990
265338 2020-06-24 Suffolk Massachusetts 25025 19628 984
262285 2020-06-23 Suffolk Massachusetts 25025 19601 976
259238 2020-06-22 Suffolk Massachusetts 25025 19567 979
256189 2020-06-21 Suffolk Massachusetts 25025 19551 978
253143 2020-06-20 Suffolk Massachusetts 25025 19528 973
250103 2020-06-19 Suffolk Massachusetts 25025 19493 971
247068 2020-06-18 Suffolk Massachusetts 25025 19477 963
244036 2020-06-17 Suffolk Massachusetts 25025 19434 959
241003 2020-06-16 Suffolk Massachusetts 25025 19367 952
237972 2020-06-15 Suffolk Massachusetts 25025 19334 951
234943 2020-06-14 Suffolk Massachusetts 25025 19335 950
231916 2020-06-13 Suffolk Massachusetts 25025 19299 943
228891 2020-06-12 Suffolk Massachusetts 25025 19249 941
225866 2020-06-11 Suffolk Massachusetts 25025 19195 938
222844 2020-06-10 Suffolk Massachusetts 25025 19099 936
219827 2020-06-09 Suffolk Massachusetts 25025 19067 935
216812 2020-06-08 Suffolk Massachusetts 25025 19028 931
213800 2020-06-07 Suffolk Massachusetts 25025 19001 924
210792 2020-06-06 Suffolk Massachusetts 25025 18955 923
207788 2020-06-05 Suffolk Massachusetts 25025 18858 922
204787 2020-06-04 Suffolk Massachusetts 25025 18790 913
201787 2020-06-03 Suffolk Massachusetts 25025 18733 908
198791 2020-06-02 Suffolk Massachusetts 25025 18636 902
195800 2020-06-01 Suffolk Massachusetts 25025 18581 896
192810 2020-05-31 Suffolk Massachusetts 25025 17936 871
189823 2020-05-30 Suffolk Massachusetts 25025 17873 868
186840 2020-05-29 Suffolk Massachusetts 25025 17786 861
183862 2020-05-28 Suffolk Massachusetts 25025 17698 852
180887 2020-05-27 Suffolk Massachusetts 25025 17596 850
177921 2020-05-26 Suffolk Massachusetts 25025 17533 844
174957 2020-05-25 Suffolk Massachusetts 25025 17480 839
171994 2020-05-24 Suffolk Massachusetts 25025 17417 838
169032 2020-05-23 Suffolk Massachusetts 25025 17291 827
166075 2020-05-22 Suffolk Massachusetts 25025 17180 818
163119 2020-05-21 Suffolk Massachusetts 25025 17089 813
160170 2020-05-20 Suffolk Massachusetts 25025 16962 807
157224 2020-05-19 Suffolk Massachusetts 25025 16825 797
154286 2020-05-18 Suffolk Massachusetts 25025 16671 793
151352 2020-05-17 Suffolk Massachusetts 25025 16479 787
148421 2020-05-16 Suffolk Massachusetts 25025 16346 778
145495 2020-05-15 Suffolk Massachusetts 25025 15996 768
142574 2020-05-14 Suffolk Massachusetts 25025 15881 759
139658 2020-05-13 Suffolk Massachusetts 25025 15587 749
136743 2020-05-12 Suffolk Massachusetts 25025 15454 732
133832 2020-05-11 Suffolk Massachusetts 25025 15356 731
130920 2020-05-10 Suffolk Massachusetts 25025 15279 718
128009 2020-05-09 Suffolk Massachusetts 25025 15119 703
125101 2020-05-08 Suffolk Massachusetts 25025 14944 683
122198 2020-05-07 Suffolk Massachusetts 25025 14732 663
119305 2020-05-06 Suffolk Massachusetts 25025 14476 642
116423 2020-05-05 Suffolk Massachusetts 25025 14173 609
113546 2020-05-04 Suffolk Massachusetts 25025 13941 596
110672 2020-05-03 Suffolk Massachusetts 25025 13777 588
107804 2020-05-02 Suffolk Massachusetts 25025 13606 569
104944 2020-05-01 Suffolk Massachusetts 25025 13295 550
102088 2020-04-30 Suffolk Massachusetts 25025 12890 524
99240 2020-04-29 Suffolk Massachusetts 25025 12539 504
96398 2020-04-28 Suffolk Massachusetts 25025 12140 469
93566 2020-04-27 Suffolk Massachusetts 25025 11883 448
90748 2020-04-26 Suffolk Massachusetts 25025 11543 424
87935 2020-04-25 Suffolk Massachusetts 25025 11218 391
85128 2020-04-24 Suffolk Massachusetts 25025 10724 372
82327 2020-04-23 Suffolk Massachusetts 25025 9739 346
79535 2020-04-22 Suffolk Massachusetts 25025 9060 318
76752 2020-04-21 Suffolk Massachusetts 25025 8669 285
73975 2020-04-20 Suffolk Massachusetts 25025 8314 263
71206 2020-04-19 Suffolk Massachusetts 25025 8074 238
68445 2020-04-18 Suffolk Massachusetts 25025 7696 214
65698 2020-04-17 Suffolk Massachusetts 25025 7272 190
62963 2020-04-16 Suffolk Massachusetts 25025 6820 166
60245 2020-04-15 Suffolk Massachusetts 25025 6279 147
57539 2020-04-14 Suffolk Massachusetts 25025 5872 120
54844 2020-04-13 Suffolk Massachusetts 25025 5579 106
52166 2020-04-12 Suffolk Massachusetts 25025 5359 88
49499 2020-04-11 Suffolk Massachusetts 25025 4926 81
46860 2020-04-10 Suffolk Massachusetts 25025 4534 73
44255 2020-04-09 Suffolk Massachusetts 25025 4041 56
41682 2020-04-08 Suffolk Massachusetts 25025 3600 50
39133 2020-04-07 Suffolk Massachusetts 25025 3245 42
36628 2020-04-06 Suffolk Massachusetts 25025 2929 33
34169 2020-04-05 Suffolk Massachusetts 25025 2658 29
31744 2020-04-04 Suffolk Massachusetts 25025 2429 28
29366 2020-04-03 Suffolk Massachusetts 25025 2183 23

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 1085.763ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette