Skip to content

Instantly share code, notes, and snippets.

@portableant

portableant/hoardNumbers.csv

Last active January 13, 2016 13:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save portableant/e980827a38056d2e1524 to your computer and use it in GitHub Desktop.
Save portableant/e980827a38056d2e1524 to your computer and use it in GitHub Desktop.
Download ZIP
Mine PAS for end date for NW hoards
Raw
hoardNumbers.csv
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
id old_findID fromdate todate
1 751327 LVPL-4B8ED8 NA NA
2 744082 LVPL-3C9A2B 75 175
3 741185 LVPL-AD0441 75 175
4 661249 LVPL-E332C6 NA NA
5 656729 LVPL-15E376 NA NA
6 651126 LANCUM-33EBC3 335 353
7 636984 LVPL-99B13B 75 175
8 632111 LVPL-B44185 190 220
9 632097 LVPL-B38AFC 318 388
10 621156 LANCUM-5B5C83 NA NA
11 616844 LANCUM-4DC831 NA NA
12 604347 LANCUM-4909B8 -1500 410
13 600192 LVPL-4F4C76 75 175
14 572241 LANCUM-3A83C7 64 158
15 561264 LVPL-B9E875 75 175
16 561057 LVPL-B5DEE8 161 180
17 561046 LVPL-B5A311 161 180
18 561036 LVPL-B55DF7 138 161
19 561027 LVPL-B53138 177 192
20 561006 LVPL-B4BA24 117 138
21 561002 LVPL-B497E7 161 169
22 560993 LVPL-B45E81 161 169
23 560982 LVPL-B43455 41 260
24 560977 LVPL-B420C1 138 161
25 560965 LVPL-B3F851 139 161
26 540520 LVPL-E98DA3 96 98
27 540501 LVPL-E94E82 98 117
28 540493 LVPL-E93482 32 191
29 540490 LVPL-E92974 32 191
30 540487 LVPL-E91FC5 32 191
31 539755 LVPL-827703 32 191
32 539748 LVPL-826570 32 191
33 539744 LVPL-8252F3 96 138
34 539738 LVPL-8241D6 96 138
35 539732 LVPL-823526 32 191
36 539726 LVPL-822641 141 NA
37 539723 LVPL-821510 138 192
38 539716 LVPL-8202B1 138 192
39 539708 LVPL-81EE43 147 NA
40 539703 LVPL-81DF54 32 191
41 539699 LVPL-81D417 32 191
42 539694 LVPL-81C491 32 191
43 539692 LVPL-81B955 32 191
44 539684 LVPL-81A2D1 161 175
45 539677 LVPL-818EB8 171 NA
46 539671 LVPL-8173B5 97 NA
47 539625 LVPL-80A5B4 187 NA
48 539622 LVPL-808D84 118 NA
49 539609 LVPL-807586 96 138
50 539597 LVPL-803FF2 98 117
51 539592 LVPL-802CC7 32 191
52 539573 LVPL-7F9E36 32 191
53 539572 LVPL-7F8EF7 32 191
54 539570 LVPL-7F80E0 32 191
55 539568 LVPL-7F7647 32 191
56 539565 LVPL-7F6AF4 32 191
57 539563 LVPL-7F61E0 32 191
58 539560 LVPL-7F5A05 32 191
59 539559 LVPL-7F5175 32 191
60 539557 LVPL-7F4777 32 191
61 539554 LVPL-7F3BD5 32 191
62 539546 LVPL-7F13F1 32 191
63 539543 LVPL-7F0391 32 191
64 533007 LVPL-888F20 75 175
65 525241 LANCUM-E88322 -32 161
66 508717 LVPL-1C0D74 -32 191
67 508711 LVPL-1BEB61 NA NA
68 508703 LVPL-1BAC98 32 191
69 508627 LVPL-180D95 75 175
70 508470 LVPL-072FE2 127 NA
71 508469 LVPL-0725B8 69 NA
72 508462 LVPL-06F245 138 NA
73 507718 LVPL-9E5A56 45 300
74 507712 LVPL-9E4C42 45 150
75 507605 LVPL-9BCE31 75 175
76 507571 LVPL-9B01F4 138 161
77 507563 LVPL-9AD156 117 138
78 507419 LVPL-89ABD3 -32 191
79 507414 LVPL-89A141 -32 191
80 507398 LVPL-8965E6 NA NA
81 507384 LVPL-892374 175 192
82 507377 LVPL-88E614 96 98
83 507369 LVPL-8888E2 161 180
84 507366 LVPL-884202 69 79
85 507360 LVPL-882432 175 192
86 507356 LVPL-8805B3 NA NA
87 507353 LVPL-87DA75 180 192
88 507350 LVPL-87BC48 112 113
89 507308 LVPL-86CEF6 NA NA
90 507346 LVPL-879098 -32 191
91 507341 LVPL-877D27 69 79
92 507327 LVPL-8718D4 117 138
93 507321 LVPL-870753 139 161
94 507313 LVPL-86DEC5 NA NA
95 507304 LVPL-86BA67 NA NA
96 507298 LVPL-86A551 175 177
97 507292 LVPL-8690C2 175 192
98 507284 LVPL-8675B8 117 138
99 507277 LVPL-866143 138 161
100 507270 LVPL-864D60 161 NA
101 507263 LVPL-8639C1 98 117
102 507251 LVPL-862093 98 117
103 507244 LVPL-860CC0 NA NA
104 507118 LVPL-752DD6 166 NA
105 507107 LVPL-74F003 159 160
106 507098 LVPL-74D314 -213 -27
107 507085 LVPL-7494B0 69 NA
108 507081 LVPL-747C81 134 138
109 507076 LVPL-7465B3 103 111
110 507069 LVPL-744734 88 NA
111 507056 LVPL-73FC46 125 128
112 507045 LVPL-73D3B7 75 NA
113 507036 LVPL-73AB58 138 161
114 507034 LVPL-739713 125 128
115 507031 LVPL-737E68 117 138
116 507026 LVPL-735981 117 138
117 507019 LVPL-7339A3 103 111
118 507011 LVPL-7311C1 162 163
119 507009 LVPL-72F093 148 149
120 507003 LVPL-72CBF5 175 180
121 506998 LVPL-72A636 152 153
122 506993 LVPL-728B63 138 161
123 435966 LVPL-1C4B82 364 378
124 435964 LVPL-1C3A92 364 378
125 435962 LVPL-1C2673 364 378
126 435960 LVPL-1C1636 364 378
127 435958 LVPL-1C05D4 364 378
128 435955 LVPL-1BF1D5 364 378
129 435954 LVPL-1BE4E7 364 378
130 435951 LVPL-1BD327 364 378
131 435942 LVPL-1BA963 364 375
132 435935 LVPL-1B8C67 364 375
133 435926 LVPL-1B6296 330 335
134 435924 LVPL-1B54E1 330 335
135 435920 LVPL-1B3C01 330 335
136 435918 LVPL-1B2E42 330 335
137 435916 LVPL-1B1AA1 335 340
138 435912 LVPL-1B02F1 335 340
139 435906 LVPL-1AED27 335 340
140 435902 LVPL-1AD354 330 335
141 435898 LVPL-1AB1C7 330 335
142 435895 LVPL-1A8995 364 375
143 435892 LVPL-1A75B8 364 378
144 435887 LVPL-1A4EE7 364 378
145 435884 LVPL-1A3022 364 378
146 435881 LVPL-1A14E2 367 378
147 435877 LVPL-19F985 364 378
148 435873 LVPL-19DAE2 354 361
149 435868 LVPL-19B713 354 361
150 435787 LVPL-0B9520 318 324
151 435781 LVPL-0B56C4 318 324
152 435777 LVPL-0B3C51 364 378
153 435775 LVPL-0B2688 364 378
154 435752 LVPL-0A37F4 307 317
155 435768 LVPL-0AF526 378 383
156 435766 LVPL-0AD962 348 350
157 435764 LVPL-0AC504 348 350
158 435762 LVPL-0AA592 346 347
159 435760 LVPL-0A8416 346 347
160 435758 LVPL-0A6162 286 293
161 435746 LVPL-09F755 310 312
162 435744 LVPL-09CFA5 268 270
163 435739 LVPL-098970 268 270
164 435734 LVPL-092F04 260 268
165 435729 LVPL-091276 98 117
166 435719 LVPL-08EE27 145 180
167 435710 LVPL-089D72 364 378
168 435706 LVPL-087A15 330 335
169 435702 LVPL-084DD7 330 335
170 421761 HESH-F40A34 364 378
171 415761 LVPL-131DE4 -91 NA
172 411692 LANCUM-009B63 NA NA
173 404935 LANCUM-F8A5F6 250 410
174 404767 LANCUM-E48D73 75 250
175 404002 LVPL-3C8B71 -2 9
176 403997 LVPL-3C5036 -213 -227
177 403994 LVPL-3C3815 -48 NA
178 403990 LVPL-3C02A0 -58 NA
179 403987 LVPL-3BDC05 -82 NA
180 403985 LVPL-3BC5F4 -109 -108
181 403983 LVPL-3BA7F1 -118 NA
182 403212 LVPL-B9C6D1 -130 NA
183 393033 LANCUM-F58816 320 340
184 391306 LANCUM-D00858 69 79
185 385780 LANCUM-862E71 250 300
186 384837 LVPL-305E93 260 410
187 291385 LANCUM-8FF497 NA NA
188 260140 LVPL-65C3E8 268 270
189 225696 LVPL-DF7591 268 270
190 183374 LVPL-00DCE2 75 351
191 176889 LVPL-B8BD62 68 69
192 147247 LANCUM-E344F1 337 341
193 147244 LANCUM-E341A6 260 268
194 147242 LANCUM-E33E64 100 200
195 147240 LANCUM-E33A13 200 400
196 147238 LANCUM-E33755 280 300
197 147237 LANCUM-E333D1 280 300
198 147235 LANCUM-E331B3 280 300
199 147234 LANCUM-E32F03 280 300
200 147231 LANCUM-E32AE7 280 300
201 147230 LANCUM-E327C6 280 300
202 147229 LANCUM-E32320 280 300
203 147228 LANCUM-E32081 280 300
204 147226 LANCUM-E31DA2 271 273
205 147224 LANCUM-E31AB5 271 273
206 147223 LANCUM-E31867 271 273
207 147221 LANCUM-E315E6 271 273
208 147219 LANCUM-E312C8 271 273
209 147218 LANCUM-E30F47 270 300
210 147215 LANCUM-E30336 270 300
211 135272 LANCUM-2CD168 200 1500
212 125078 DENO-EF9928 268 270
213 125069 DENO-EF73E4 269 273
214 125055 DENO-EF5D28 269 271
215 125038 DENO-EF20B5 354 361
216 125035 DENO-EF0E53 364 375
217 125028 DENO-EEE312 364 378
218 125025 DENO-EECB26 364 378
219 125022 DENO-EEB321 378 383
220 125013 DENO-EE8F86 364 378
221 124998 DENO-EE4E92 350 360
222 120790 LANCUM-E37212 -32 -31
223 108085 LVPL-9537D4 306 423
224 63934 LANCUM-95B9D3 -32 -31
Raw
minePAS.R
library(jsonlite)
url <- 'https://finds.org.uk/database/search/results/q/hoard/broadperiod/ROMAN/regionID/41431/format/json'
json <- fromJSON(url)
total <- json$meta$totalResults
results <- json$meta$resultsPerPage
pagination <- ceiling(total/results)
keeps <- c("id","old_findID","fromdate", "todate")
data <- json$results
data <- data[,(names(data) %in% keeps)]
for (i in seq(from=2, to=pagination, by=1)){
urlDownload <- paste(url, '/page/', i, sep='')
pagedJson <- fromJSON(urlDownload)
records <- pagedJson$results
records <- records[,(names(records) %in% keeps)]
data <-rbind(data,records)
}
occurences <-table(unlist(data$todate))
t <- as.data.frame(occurences)
names(t) <- c('terminalDate', 'frequency')
write.csv(t, file='hoards.csv',row.names=FALSE, na="")
plot(frequency ~ terminalDate, t)
Raw
rawData.csv
terminalDate frequency
-227 1
-137 1
-113 1
-112 1
-108 1
-100 1
-95 1
-90 1
-83 1
-82 1
-50 2
-48 2
-46 1
-42 1
-31 22
-27 8
-16 2
-6 1
9 2
14 7
37 19
42 2
43 1
50 9
54 6
60 3
68 2
69 4
70 4
73 1
75 1
78 2
79 8
80 2
81 1
83 1
96 4
98 5
99 1
100 14
102 2
111 8
113 1
117 29
120 1
122 1
125 2
128 4
134 2
137 3
138 29
144 4
145 1
147 1
149 2
150 15
152 1
153 1
154 1
156 1
158 1
159 1
160 1
161 40
162 1
163 2
164 1
165 1
169 6
171 1
172 5
173 1
175 17
176 7
177 1
179 2
180 12
183 2
184 2
187 1
190 1
191 29
192 23
195 1
196 2
197 1
198 1
199 5
200 49
201 1
202 2
210 4
211 8
212 2
215 4
217 4
220 3
222 3
224 1
235 9
236 1
238 1
239 1
240 1
243 1
246 1
247 2
249 4
250 7
251 1
253 1
258 1
259 1
260 20
261 1
265 2
266 1
267 1
268 51
269 25
270 47
271 54
273 8
274 78
275 30
276 1
279 1
282 8
285 55
286 3
290 1
293 17
294 2
295 1
296 31
298 1
299 1
300 29
305 7
307 2
308 4
310 5
312 3
313 7
314 5
315 5
316 1
317 7
318 17
319 1
320 2
322 2
323 3
324 27
325 3
326 2
328 2
329 1
330 7
331 1
333 2
334 1
335 43
337 6
340 20
341 26
347 2
348 35
350 17
351 1
352 1
353 12
354 6
355 3
356 40
360 5
361 46
363 6
364 5
365 5
367 14
375 39
378 132
383 12
387 3
388 13
392 4
394 1
395 21
400 53
401 1
402 104
405 1
406 3
408 10
409 2
410 60
423 3
450 2
490 1
600 1
650 1
700 1
1100 1
1400 1
1500 1
1700 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment