names

125 rows where place_id = 586542

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588997 1864209 1864209 defendant Couper Robert carpenter 586542 586542 Couper, Robert, of Charryng, carpenter 0
3618025 1873258 1873258 defendant Attehacche Hugh yeoman 586542 586542 Attehacche, Hugh, of Charryng, yeoman 0
3620341 1873943 1873943 defendant Athacch Hugh yeoman 586542 586542 Athacch, Hugh, of Charryng, yeoman 0
3621039 1874138 1874138 defendant at Hacche Hugh yeoman 586542 586542 at Hacche, Hugh, of Charryng, yeoman 0
3621043 1874138 1874138 defendant Brent John gent 586542 586542 Brent, John, of Charryng, gent 4
3639711 1907228 1907228 defendant Millall William chapman 586542 586542 Millall, William, of Charryng, chapman 1
3682359 1920584 1920584 defendant Geffrey John husbandman 586542 586542 Geffrey, John, of Charryng, husbandman 0
3861541 1977323 1977323 defendant Hylde Hugh butcher 586542 586542 Hylde, Hugh, of Charryng, butcher 0
3949982 2007074 2007074 defendant Tanner William husbandman 586542 586542 Tanner, William, of Charryng, husbandman 0
4630444 2240432 2240432 defendant Haukere John   586542 586542 Haukere, John, of Charryng 3
4657704 2248296 2248296 defendant North Richard yeoman 586542 586542 North, Richard, of Charryng, yeoman 0
4759158 2283209 2283209 plaintiff Chapman William   586542 586542 Chapman, William, of Charryng 0
4873619 2318687 2318687 defendant Dodyngton Henry smith 586542 586542 Dodyngton, Henry, of Charryng, smith 3
4887379 2322889 2322889 defendant Tubbe Richard husbandman 586542 586542 Tubbe, Richard, of Charryng, husbandman 1
4907927 2329037 2329037 defendant Bedyll John laborer 586542 586542 Bedyll, John, of Charryng, laborer 0
4916245 2331585 2331585 defendant Leche Robert baker 586542 586542 Leche, Robert, of Charryng, baker 4
4929968 2335780 2335780 defendant Prat William yeoman 586542 586542 Prat, William, of Charryng, yeoman 2
4939293 2338671 2338671 defendant Prat William yeoman 586542 586542 Prat, William, of Charryng, yeoman 1
4964991 2346446 2346446 defendant Prat William husbandman 586542 586542 Prat, William, of Charryng, husbandman 1
4976363 2349891 2349891 defendant Clerk Roger husbandman 586542 586542 Clerk, Roger, of Charryng, husbandman 0
4978461 2350505 2350505 defendant Aldyn Thomas laborer 586542 586542 Aldyn, Thomas, of Charryng, laborer 2
4986248 2352816 2352816 defendant Mayhewe Robert husbandman 586542 586542 Mayhewe, Robert, of Charryng, husbandman 1
5002989 2357776 2357776 defendant Barscombe Thomas tanner 586542 586542 Barscombe, Thomas, of Charryng, tanner 0
5013313 2360732 2360732 defendant Ive William tailor 586542 586542 Ive, William, of Charryng, tailor 1
5013314 2360732 2360732 defendant Brewer John carpenter 586542 586542 Brewer, John, of Charryng, carpenter 2
5020347 2362835 2362835 defendant Ive William tailor 586542 586542 Ive, William, of Charryng, tailor 0
5047998 2371022 2371022 defendant Brawer John laborer 586542 586542 Brawer, John, of Charryng, laborer 1
5057295 2373749 2373749 defendant Crips John husbandman 586542 586542 Crips, John, of Charryng, husbandman 1
5069623 2377410 2377410 defendant Hancok Alice widow 586542 586542 Hancok, Alice, of Charryng, widow 2
5075974 2379307 2379307 defendant Tondyeux John husbandman 586542 586542 Tondyeux, John, of Charryng, or of Newenden, husbandman 0
5075975 2379307 2379307 defendant Mapelysden Henry husbandman 586542 586542 Mapelysden, Henry, of Charryng, husbandman 1
5078241 2379978 2379978 defendant Holden John husbandman 586542 586542 Holden, John, of Charryng, husbandman 0
5111694 2389818 2389818 defendant Ovyngton John gent 586542 586542 Ovyngton, John, of Charryng, gent 0
5136631 2397235 2397235 defendant Coumbe (illegible) husbandman 586542 586542 Coumbe, ---, of Charryng, husbandman 1
5151614 2401628 2401628 defendant Pratte William barber 586542 586542 Pratte, William, of Charryng, barber 0
5151615 2401628 2401628 defendant Pratte Robert husbandman 586542 586542 Pratte, Robert, of Charryng, husbandman 1
5164285 2405292 2405292 defendant Adesam Roger laborer 586542 586542 Adesam, Roger, of Charryng, laborer 1
5186802 2411886 2411886 defendant Pratte William barber 586542 586542 Pratte, William, of Charryng, barber 0
5186803 2411886 2411886 defendant Pratte Robert husbandman 586542 586542 Pratte, Robert, of Charryng, husbandman 1
5192049 2413403 2413403 defendant Pratte Robert husbandman 586542 586542 Pratte, Robert, of Charryng, husbandman 2
5192060 2413405 2413405 defendant Pratte Robert husbandman 586542 586542 Pratte, Robert, of Charryng, husbandman 3
5192065 2413406 2413406 defendant Pratte Robert husbandman 586542 586542 Pratte, Robert, of Charryng, husbandman 3
5207472 2417925 2417925 defendant Pratte Robert husbandman 586542 586542 Pratte, Robert, of Charryng, husbandman 3
5213906 2419797 2419797 defendant Holden John husbandman 586542 586542 Holden, John, of Charryng, husbandman 1
5213908 2419797 2419797 defendant Rye Richard husbandman 586542 586542 Rye, Richard, of Charryng, husbandman 3
5214261 2419903 2419903 defendant Tubbe Thomas husbandman 586542 586542 Tubbe, Thomas, of Charryng, husbandman 0
5218267 2421073 2421073 defendant Prat William barber 586542 586542 Prat, William, of Charryng, barber 1
5232064 2424950 2424950 defendant Tubbe Henry husbandman 586542 586542 Tubbe, Henry, of Charryng, husbandman 0
5236016 2426115 2426115 plaintiff Duke John   586542 586542 Duke, John, of Charryng 0
5252202 2430802 2430802 defendant Marchall William miller 586542 586542 Marchall, William, of Charryng, miller 3
5253713 2431275 2431275 defendant Kent Richard laborer 586542 586542 Kent, Richard, of Charryng, laborer 0
5265759 2435041 2435041 defendant Mapelysden Henry yeoman 586542 586542 Mapelysden, Henry, of Charryng, yeoman 0
5267305 2435537 2435537 defendant Hamon Alice widow 586542 586542 Hamon, Alice, of Charryng, widow 3
5297925 2444402 2444402 defendant Spere William clerk 586542 586542 Spere, William, of Charryng, clerk 0
5335763 2455762 2455762 defendant atte Hacche Hugh yeoman 586542 586542 atte Hacche, Hugh, of Charryng, yeoman 0
5335764 2455762 2455762 defendant Grymmysby William yeoman 586542 586542 Grymmysby, William, of Charryng, yeoman 1
5345417 2458739 2458739 defendant Calwood Robert carpenter 586542 586542 Calwood, Robert, of Charryng, carpenter 0
5347127 2459260 2459260 defendant Gymmys- William yeoman 586542 586542 Gymmys-, William, of Charryng, yeoman 2
5348107 2459552 2459552 defendant Hacche Hugh yeoman 586542 586542 Hacche, Hugh, of Charryng, yeoman 0
5365976 2465018 2465018 defendant Hanche or Haithe Hugh yeoman 586542 586542 Hanche or Haithe, Hugh, of Charryng, yeoman 0
5366502 2465179 2465179 defendant Pympe Reginald gent 586542 586542 Pympe, Reginald, of Charryng, gent 1
5367186 2465386 2465386 defendant Couper Robert carpenter 586542 586542 Couper, Robert, of Charryng, carpenter 0
5371531 2466682 2466682 defendant Paunsherst Thomas yeoman 586542 586542 Paunsherst, Thomas, of Charryng, yeoman 0
5371532 2466682 2466682 defendant Godard John, senior smith 586542 586542 Godard, John, senior, of Charryng, smith 1
5371636 2466716 2466716 defendant Hotrough Thomas yeoman 586542 586542 Hotrough, Thomas, of Charryng, yeoman 0
5371637 2466716 2466716 defendant Ford John, senior smith 586542 586542 Ford, John, senior, of Charryng, smith 1
5372360 2466950 2466950 defendant Couper Robert carpenter 586542 586542 Couper, Robert, of Charryng, carpenter 0
5373159 2467202 2467202 defendant Couper Robert carpenter 586542 586542 Couper, Robert, of Charryng, carpenter 0
5386456 2471199 2471199 defendant Couper Robert carpenter 586542 586542 Couper, Robert, of Charryng, carpenter 0
5386457 2471199 2471199 defendant Towenysfeld Robert laborer 586542 586542 Towenysfeld, Robert, of Charryng, laborer 1
5386458 2471199 2471199 defendant Edward John laborer 586542 586542 Edward, John, of Charryng, laborer 2
5390231 2472269 2472269 defendant Couper Robert carpenter 586542 586542 Couper, Robert, of Charryng, carpenter 0
5397150 2474268 2474268 defendant Hatche Hugh yeoman 586542 586542 Hatche, Hugh, of Charryng, yeoman 0
5397202 2474285 2474285 defendant Brent William gent 586542 586542 Brent, William, of Charryng, gent 0
5401134 2475388 2475388 defendant Godeard Robert smith 586542 586542 Godeard, Robert, of Charryng, smith 2
5405217 2476578 2476578 defendant Hatche Hugh yeoman 586542 586542 Hatche, Hugh, of Charryng, yeoman 0
5410404 2478062 2478062 defendant Brent William gent 586542 586542 Brent, William, of Charryng, gent 0
5418289 2480397 2480397 defendant Hacche Hugh yeoman 586542 586542 Hacche, Hugh, of Charryng, yeoman 0
5423485 2481984 2481984 defendant Moyle Margaret widow 586542 586542 Moyle, Margaret, of Charryng, widow 0
5423486 2481984 2481984 defendant Gorlyn Robert gent 586542 586542 Gorlyn, Robert, of Charryng, gent 1
5423838 2482085 2482085 defendant Couper Robert carpenter 586542 586542 Couper, Robert, of Charryng, carpenter 3
5424249 2482218 2482218 defendant Brent William gent 586542 586542 Brent, William, of Charryng, gent 0
5424254 2482219 2482219 defendant Brent William gent 586542 586542 Brent, William, of Charryng, gent 0
5424259 2482220 2482220 defendant Brent William gent 586542 586542 Brent, William, of Charryng, gent 0
5425252 2482523 2482523 defendant Couper Robert carpenter 586542 586542 Couper, Robert, of Charryng, carpenter 0
5429813 2483859 2483859 defendant Goddard Robert smith 586542 586542 Goddard, Robert, of Charryng, smith 0
5430396 2484026 2484026 defendant Brent William gent 586542 586542 Brent, William, of Charryng, gent 0
5430398 2484026 2484026 defendant Nyn Robert yeoman 586542 586542 Nyn, Robert, of Charryng, yeoman 2
5431908 2484511 2484511 defendant Brent William gent 586542 586542 Brent, William, of Charryng, gent 0
5431910 2484511 2484511 defendant Nyn Robert yeoman 586542 586542 Nyn, Robert, of Charryng, yeoman 2
5437983 2486297 2486297 defendant Couper Robert husbandman 586542 586542 Couper, Robert, of Charryng, husbandman 3
5442767 2487749 2487749 defendant Moyle Margaret widow 586542 586542 Moyle, Margaret, of Charryng, widow 0
5443062 2487834 2487834 defendant Brent William gent 586542 586542 Brent, William, of Charryng, gent 0
5446735 2488920 2488920 defendant Godard Robert smith 586542 586542 Godard, Robert, of Charryng, smith 0
5452726 2490698 2490698 defendant Belle William yeoman 586542 586542 Belle, William, of Charryng, yeoman 0
5455483 2491551 2491551 defendant Moyle Margaret widow 586542 586542 Moyle, Margaret, of Charryng, widow 0
5455484 2491551 2491551 defendant Gorlyng Robert gent 586542 586542 Gorlyng, Robert, of Charryng, gent 1
5458973 2492578 2492578 defendant Brent William gent 586542 586542 Brent, William, of Charryng, gent 1
5464017 2494154 2494154 defendant Couper Robert husbandman 586542 586542 Couper, Robert, of Charryng, husbandman 3
5467268 2495157 2495157 defendant Moyle Margaret widow 586542 586542 Moyle, Margaret, of Charryng, widow 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);