names

208 rows where place_id = 624220

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3756754 1944085 1944085 defendant Pyrry John husbandman 624220 624220 Pyrry, John, of Crukern, husbandman 2
3920543 1997219 1997219 defendant Hannyng John yeoman 624220 624220 Hannyng, John, of Crukern, yeoman 0
3920545 1997220 1997220 defendant Hannyng John yeoman 624220 624220 Hannyng, John, of Crukern, yeoman 0
3981078 2017992 2017992 defendant Meryfyld Robert yeoman 624220 624220 Meryfyld, Robert, of Crukern, yeoman 1
3981079 2017992 2017992 defendant Baker Robert yeoman 624220 624220 Baker, Robert, of Crukern, yeoman 2
3981083 2017993 2017993 defendant Yard William shoemaker 624220 624220 Yard, William, of Crukern, shoemaker 1
4444494 2183259 2183259 plaintiff Cokkes William   624220 624220 Cokkes, William, of Crukern 0
4444607 2183289 2183289 defendant Mulwer John   624220 624220 Mulwer, John, of Crukern 0
4448097 2184325 2184325 plaintiff Fissher William   624220 624220 Fissher, William, of Crukern 0
4466081 2190050 2190050 plaintiff Wysman Richard   624220 624220 Wysman, Richard, of Crukern 0
4467710 2190577 2190577 plaintiff Baker Thomas   624220 624220 Baker, Thomas, of Crukern 0
4468335 2190762 2190762 defendant Broun Robert   624220 624220 Broun, Robert, of Crukern 0
4469451 2191109 2191109 defendant Bocher Robert   624220 624220 Bocher, Robert, of Crukern 0
4482786 2195323 2195323 defendant Gregory William   624220 624220 Gregory, William, of Crukern 0
4491984 2198181 2198181 defendant Smyth Richard   624220 624220 Smyth, Richard, of Crukern 1
4491992 2198184 2198184 plaintiff Wyke John   624220 624220 Wyke, John, of Crukern 0
4491993 2198184 2198184 defendant Bocher William   624220 624220 Bocher, William, of Crukern 0
4491994 2198185 2198185 plaintiff Wyke John   624220 624220 Wyke, John, of Crukern 0
4491998 2198186 2198186 plaintiff Wyke John   624220 624220 Wyke, John, of Crukern 0
4494455 2198966 2198966 defendant Dyer Walter   624220 624220 Dyer, Walter, of Crukern 0
4498642 2200216 2200216 defendant Smyth Richard   624220 624220 Smyth, Richard, of Crukern 1
4498644 2200216 2200216 defendant B--- John   624220 624220 B---, John, of Crukern 3
4505028 2202107 2202107 defendant Brasyere John   624220 624220 Brasyere, John, of Crukern 1
4512158 2204249 2204249 defendant Baker Thomas   624220 624220 Baker, Thomas, of Crukern 0
4512160 2204250 2204250 defendant Baker Thomas   624220 624220 Baker, Thomas, of Crukern 0
4512161 2204250 2204250 defendant Dene John   624220 624220 Dene, John, of Crukern 1
4514922 2205077 2205077 defendant Spore John   624220 624220 Spore, John, of Crukern 0
4515422 2205238 2205238 defendant Bakere Thomas   624220 624220 Bakere, Thomas, of Crukern 1
4515897 2205393 2205393 defendant Smyth William   624220 624220 Smyth, William, of Crukern 0
4521069 2206928 2206928 defendant Spore John merchant 624220 624220 Spore, John, of Crukern, merchant 0
4524614 2208031 2208031 defendant Spore John draper 624220 624220 Spore, John, of Crukern, draper 3
4525538 2208317 2208317 defendant Baker Thomas   624220 624220 Baker, Thomas, of Crukern 2
4528549 2209204 2209204 defendant Boucher Geoffrey   624220 624220 Boucher, Geoffrey, of Crukern 0
4533760 2210825 2210825 defendant Broune John   624220 624220 Broune, John, of Crukern 0
4534767 2211154 2211154 defendant _omcher Geoffrey   624220 624220 _omcher, Geoffrey, of Crukern 1
4535248 2211290 2211290 defendant Baker Thomas   624220 624220 Baker, Thomas, of Crukern 0
4536158 2211584 2211584 plaintiff Spore John draper 624220 624220 Spore, John, of Crukern, draper 0
4538807 2212411 2212411 defendant Spore John   624220 624220 Spore, John, of Crukern 0
4538811 2212412 2212412 defendant Spore John   624220 624220 Spore, John, of Crukern 0
4541684 2213295 2213295 plaintiff Wyke John   624220 624220 Wyke, John, of Crukern 0
4541690 2213296 2213296 plaintiff Wyke John   624220 624220 Wyke, John, of Crukern 0
4541696 2213297 2213297 plaintiff Wyke John   624220 624220 Wyke, John, of Crukern 0
4542065 2213410 2213410 defendant Bakere Thomas   624220 624220 Bakere, Thomas, of Crukern 1
4547000 2214995 2214995 defendant Baker Thomas   624220 624220 Baker, Thomas, of Crukern 2
4548580 2215495 2215495 defendant Bakere Thomas   624220 624220 Bakere, Thomas, of Crukern 0
4549427 2215767 2215767 defendant London William   624220 624220 London, William, of Crukern 1
4550115 2215977 2215977 defendant Chaumber John   624220 624220 Chaumber, John, of Crukern 0
4550116 2215977 2215977 defendant Gregory William   624220 624220 Gregory, William, of Crukern 1
4553982 2217164 2217164 defendant Boucher Geoffrey   624220 624220 Boucher, Geoffrey, of Crukern 1
4556903 2218091 2218091 defendant London William   624220 624220 London, William, of Crukern 0
4561339 2219494 2219494 defendant Fysshe Adam   624220 624220 Fysshe, Adam, of Crukern 0
4562136 2219723 2219723 defendant Bakere Thomas   624220 624220 Bakere, Thomas, of Crukern 0
4563604 2220183 2220183 defendant Brasyetter John   624220 624220 Brasyetter, John, of Crukern 0
4563605 2220183 2220183 defendant Baker Thomas   624220 624220 Baker, Thomas, of Crukern 1
4564303 2220406 2220406 defendant Crukern Robert   624220 624220 Crukern, Robert, of Crukern 0
4567934 2221540 2221540 defendant Spore John   624220 624220 Spore, John, of Crukern 0
4570999 2222496 2222496 defendant London William   624220 624220 London, William, of Crukern 1
4571001 2222496 2222496 defendant Baker Thomas   624220 624220 Baker, Thomas, of Crukern 3
4580922 2225512 2225512 defendant James William   624220 624220 James, William, of Crukern 4
4586016 2227048 2227048 defendant Barbour John   624220 624220 Barbour, John, of Crukern 3
4589436 2228070 2228070 defendant Bulstone Robert   624220 624220 Bulstone, Robert, of Crukern 0
4594061 2229404 2229404 defendant Michell John   624220 624220 Michell, John, of Crukern 0
4594063 2229404 2229404 defendant (illegible) John   624220 624220 _, John, of Crukern 2
4594065 2229404 2229404 defendant Gregory William   624220 624220 Gregory, William, of Crukern 4
4600544 2231392 2231392 defendant Broun John   624220 624220 Broun, John, of Crukern 1
4601083 2231569 2231569 defendant Clerk John   624220 624220 Clerk, John, of Crukern 2
4601084 2231569 2231569 defendant Gylle John weaver 624220 624220 Gylle, John, of Crukern, weaver 3
4609864 2234180 2234180 defendant Bocher Joan   624220 624220 Bocher, Joan, of Crukern, formerly wife of Geoffrey Bocher 3
4614531 2235552 2235552 plaintiff Dygon Richard   624220 624220 Dygon, Richard, of Crukern 0
4626104 2239121 2239121 defendant Ganet William   624220 624220 Ganet, William, of Crukern 3
4628064 2239700 2239700 plaintiff Sadeler John   624220 624220 Sadeler, John, of Crukern 0
4648154 2245521 2245521 defendant Benet Richard butcher 624220 624220 Benet, Richard, of Crukern, butcher 0
4648685 2245670 2245670 plaintiff Tannere Gilbert   624220 624220 Tannere, Gilbert, of Crukern 0
4654785 2247374 2247374 defendant Boucher Geoffrey (legal representative) 624220 624220 Boucher, Geoffrey, of Crukern, brewer, administratrix of 4
4654788 2247374 2247374 defendant Osteler Thomas ostler 624220 624220 Osteler, Thomas, of Crukern, ostler 7
4655127 2247487 2247487 defendant Haukechurche Philip laborer 624220 624220 Haukechurche, Philip, of Crukern, laborer 0
4655130 2247487 2247487 defendant Jamys William carrier 624220 624220 Jamys, William, of Crukern, carrier 3
4655131 2247487 2247487 defendant Hyne William carrier 624220 624220 Hyne, William, of Crukern, carrier 4
4655132 2247487 2247487 defendant Soper Simon roper 624220 624220 Soper, Simon, of Crukern, roper 5
4655133 2247487 2247487 defendant Thursteyn Nicholas butcher 624220 624220 Thursteyn, Nicholas, of Crukern, butcher 6
4655134 2247487 2247487 defendant Bocher Joan widow 624220 624220 Bocher, Joan, of Crukern, widow 7
4656098 2247787 2247787 defendant Benet Richard butcher 624220 624220 Benet, Richard, of Crukern, butcher 0
4656099 2247787 2247787 defendant Palmer John butcher 624220 624220 Palmer, John, of Crukern, butcher 1
4656100 2247787 2247787 defendant Thursteyn Nicholas butcher 624220 624220 Thursteyn, Nicholas, of Crukern, butcher 2
4656101 2247787 2247787 defendant Souter Henry shoemaker 624220 624220 Souter, Henry, of Crukern, shoemaker 3
4656102 2247787 2247787 defendant Boucher Joan spinster 624220 624220 Boucher, Joan, of Crukern, spinster 4
4656433 2247906 2247906 defendant Lough Simon laborer 624220 624220 Lough, Simon, of Crukern, laborer 0
4658781 2248617 2248617 defendant Tort Hugh   624220 624220 Tort, Hugh, of Crukern 0
4663492 2250057 2250057 defendant Ganet William husbandman 624220 624220 Ganet, William, of Crukern, husbandman 0
4663495 2250058 2250058 defendant Smert John draper 624220 624220 Smert, John, of Crukern, draper 1
4667662 2255597 2255597 defendant Ile John husbandman 624220 624220 Ile, John, of Crukern, husbandman 0
4668959 2255994 2255994 defendant Longhe Simon laborer 624220 624220 Longhe, Simon, of crukern, laborer 0
4670919 2256580 2256580 defendant Forster William tanner 624220 624220 Forster, William, of Crukern, tanner 1
4670920 2256580 2256580 defendant Chapman John chapman 624220 624220 Chapman, John, of Crukern, chapman 2
4683096 2260327 2260327 defendant Bailly Thomas   624220 624220 Bailly, Thomas, of Crukern, bailiff 1
4684686 2260811 2260811 defendant Crukern John   624220 624220 Crukern, John, of Crukern, son of Robert 0
4687608 2261709 2261709 defendant Benet Richard butcher 624220 624220 Benet, Richard, of Crukern, butcher 0
4687746 2261739 2261739 defendant Banet William husbandman 624220 624220 Banet, William, of Crukern, husbandman 5
4688307 2261911 2261911 defendant Bury John tanner 624220 624220 Bury, John, of Crukern, tanner 1
4689272 2262207 2262207 plaintiff Typpe John   624220 624220 Typpe, John, of Crukern 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);