names

86 rows where place_id = 600359

✎ 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
3640736 1907548 1907548 defendant Chamberlayne John gent 600359 600359 Chamberlayne, John, of Shirbourne, gent 1
3685620 1921656 1921656 defendant Oke John baker 600359 600359 Oke, John, of Shirbourne, baker 0
3685621 1921656 1921656 defendant Lede John laborer 600359 600359 Lede, John, of Shirbourne, laborer 1
3698229 1925669 1925669 defendant Pope John husbandman 600359 600359 Pope, John, of Shirbourne, husbandman 0
3777695 1950773 1950773 defendant Foster Thomas husbandman 600359 600359 Foster, Thomas, of Shirbourne, husbandman 0
3815684 1962824 1962824 defendant Chamberleyn Edward   600359 600359 Chamberleyn, Edward, of Shirbourne, knight 0
3830733 1967496 1967496 defendant Court John husbandman 600359 600359 Court, John, of Shirbourne, husbandman 1
4444753 2183339 2183339 defendant Parrik John   600359 600359 Parrik, John, of Shirbourne 0
4466492 2190192 2190192 defendant Caym John   600359 600359 Caym, John, of Shirbourne 0
4495030 2199136 2199136 defendant Frome John   600359 600359 Frome, John, of Shirbourne 0
4496419 2199558 2199558 plaintiff Cote William   600359 600359 Cote, William, of Shirbourne 0
4507189 2202715 2202715 defendant Trenchest William   600359 600359 Trenchest, William, of Shirbourne, prior 0
4515165 2205159 2205159 plaintiff Chaumberleyn Simon   600359 600359 Chaumberleyn, Simon, of Shirbourne 0
4543273 2213781 2213781 defendant Lodewell Walter   600359 600359 Lodewell, Walter, of Shirbourne 0
4543274 2213781 2213781 defendant Laurence Edward   600359 600359 Laurence, Edward, of Shirbourne 1
4543280 2213783 2213783 defendant Smyth John   600359 600359 Smyth, John, of Shirbourne 0
4543900 2213994 2213994 defendant Knyght William   600359 600359 Knyght, William, of Shirbourne 0
4548168 2215366 2215366 plaintiff Chaumberleyn Simon   600359 600359 Chaumberleyn, Simon, of Shirbourne 0
4565527 2220788 2220788 plaintiff Smyth Thomas   600359 600359 Smyth, Thomas, of Shirbourne 0
4565528 2220788 2220788 defendant Fote William fuller 600359 600359 Fote, William, of Shirbourne, fuller 0
4603277 2232225 2232225 defendant Hulle William   600359 600359 Hulle, William, of Shirbourne 6
4619596 2237119 2237119 defendant Houghton Thomas smith 600359 600359 Houghton, Thomas, of Shirbourne, smith 2
4627214 2239458 2239458 defendant Knapelok William   600359 600359 Knapelok, William, of Shirbourne 0
4659123 2248726 2248726 plaintiff Dare Robert baker 600359 600359 Dare, Robert, of Shirbourne, baker 0
4659124 2248726 2248726 defendant Ilberd John gent 600359 600359 Ilberd, John, of Shirbourne, gent 0
4673581 2257369 2257369 defendant Walvall John butcher 600359 600359 Walvall, John, of Shirbourne, butcher 0
4673583 2257369 2257369 defendant Batte Peter   600359 600359 Batte, Peter, of Shirbourne, milward 2
4682319 2260095 2260095 defendant Bocher John butcher 600359 600359 Bocher, John, of Shirbourne, butcher 0
4682322 2260096 2260096 defendant Sherham Richard weaver 600359 600359 Sherham, Richard, of Shirbourne, weaver 1
4682323 2260096 2260096 defendant Laurence Richard fuller 600359 600359 Laurence, Richard, of Shirbourne, fuller 2
4698630 2265049 2265049 defendant Ilberd John gent 600359 600359 Ilberd, John, of Shirbourne, gent 0
4704442 2266765 2266765 defendant Dollyng Richard   600359 600359 Dollyng, Richard, of Shirbourne, mill ward 0
4704443 2266765 2266765 defendant Salter William chaplain 600359 600359 Salter, William, of Shirbourne, chaplain 1
4705839 2267199 2267199 defendant Haryngton William husbandman 600359 600359 Haryngton, William, of Shirbourne, husbandman 4
4708359 2267986 2267986 plaintiff Nobilet John (legal representative) 600359 600359 Nobilet, John, of Shirbourne, executors of 0
4711424 2268903 2268903 defendant White John   600359 600359 White, John, of Shirbourne, bailiff 2
4731801 2275135 2275135 plaintiff Noblet John (legal representative) 600359 600359 Noblet, John, of Shirbourne, executors of 0
4733366 2275612 2275612 plaintiff Rake Nicholas   600359 600359 Rake, Nicholas, of Shirbourne 0
4745307 2279140 2279140 defendant Carter John weaver 600359 600359 Carter, John, of Shirbourne, weaver 0
4761981 2284094 2284094 defendant Scot Laurence husbandman 600359 600359 Scot, Laurence, of Shirbourne, husbandman 2
4771358 2287025 2287025 defendant Quynton Thomas husbandman 600359 600359 Quynton, Thomas, of Shirbourne, husbandman 0
4787498 2292162 2292162 plaintiff Gybon John ironmonger 600359 600359 Gybon, John, of Shirbourne, ironmonger 0
4796332 2295001 2295001 defendant Quenyton Thomas husbandman 600359 600359 Quenyton, Thomas, of Shirbourne, husbandman 2
4796334 2295002 2295002 defendant Queynton Thomas husbandman 600359 600359 Queynton, Thomas, of Shirbourne, husbandman 0
4797590 2295419 2295419 defendant Queynton Thomas husbandman 600359 600359 Queynton, Thomas, of Shirbourne, husbandman 0
4865440 2316157 2316157 defendant Dun William weaver 600359 600359 Dun, William, of Shirbourne, weaver 3
4865446 2316158 2316158 defendant Dun William weaver 600359 600359 Dun, William, of Shirbourne, weaver 3
4868749 2317198 2317198 defendant Burdon John butcher 600359 600359 Burdon, John, of Shirbourne, butcher 0
4868750 2317198 2317198 defendant Joy John butcher 600359 600359 Joy, John, of Shirbourne, butcher 1
4897572 2325903 2325903 defendant Kene Oliver butcher 600359 600359 Kene, Oliver, of Shirbourne, butcher 0
4927607 2335072 2335072 defendant Vanne Henry fuller 600359 600359 Vanne, Henry, of Shirbourne, fuller 1
4931723 2336308 2336308 defendant Hillary John gent 600359 600359 Hillary, John, of Shirbourne, gent 0
4952169 2342615 2342615 defendant Bouchere Richard butcher 600359 600359 Bouchere, Richard, of Shirbourne, butcher 1
4991352 2354296 2354296 defendant Vele Richard   600359 600359 Vele, Richard, of Shirbourne, vicar 0
4998332 2356374 2356374 defendant Smyth William smith 600359 600359 Smyth, William, of Shirbourne, smith 0
5010357 2359898 2359898 defendant Archer Nicholas   600359 600359 Archer, Nicholas, of Shirbourne, servant 3
5012744 2360561 2360561 defendant Showere John husbandman 600359 600359 Showere, John, of Shirbourne, husbandman 0
5044059 2369850 2369850 defendant Rokys John esq 600359 600359 Rokys, John, of Shirbourne, esq 0
5050787 2371859 2371859 defendant Latche Richard merchant 600359 600359 Latche, Richard, of Shirbourne, merchant 1
5109591 2389236 2389236 defendant Furnis Elias merchant 600359 600359 Furnis, Elias, of Shirbourne, merchant 0
5112488 2390038 2390038 defendant Illary Robert gent 600359 600359 Illary, Robert, of Shirbourne, gent 0
5135781 2396979 2396979 defendant Wodelond William   600359 600359 Wodelond, William, of Shirbourne, cloth maker 0
5135782 2396979 2396979 defendant Pyle Walter   600359 600359 Pyle, Walter, of Shirbourne, cloth maker 1
5159430 2403875 2403875 defendant Russell William hosier 600359 600359 Russell, William, of Shirbourne, hosier 0
5172510 2407685 2407685 defendant Wodelond William   600359 600359 Wodelond, William, of Shirbourne, cloth maker 0
5172511 2407685 2407685 defendant Pyle Walter   600359 600359 Pyle, Walter, of Shirbourne, cloth maker 1
5174574 2408264 2408264 defendant Russell William hosier 600359 600359 Russell, William, of Shirbourne, hosier 0
5181395 2410302 2410302 defendant Lache Richard barber 600359 600359 Lache, Richard, of Shirbourne, barber 0
5192018 2413394 2413394 defendant Wodelond William   600359 600359 Wodelond, William, of Shirbourne, cloth maker 0
5192019 2413394 2413394 defendant Pyle Walter   600359 600359 Pyle, Walter, of Shirbourne, cloth maker 1
5192020 2413394 2413394 defendant Gibbes Richard   600359 600359 Gibbes, Richard, of Shirbourne, cloth maker 2
5195318 2414379 2414379 defendant Russell William hosier 600359 600359 Russell William, of Shirbourne, hosier 0
5195320 2414380 2414380 defendant Russell William hosier 600359 600359 Russell, William, of Shirbourne, hosier 0
5357589 2462443 2462443 defendant Wesser John tucker 600359 600359 Wesser, John, of Shirbourne, tucker 1
5369994 2466205 2466205 defendant Novyll John butcher 600359 600359 Novyll, John, of Shirbourne, butcher 1
5415968 2479709 2479709 defendant Caundell Richard brewer 600359 600359 Caundell, Richard, of Shirbourne, brewer 0
5441829 2487486 2487486 defendant Caundell Richard brewer 600359 600359 Caundell, Richard, of Shirbourne, brewer 0
5477956 2498431 2498431 defendant Forkys or Furkeys Elias mercer 600359 600359 Forkys or Furkeys, Elias, of Shirbourne, mercer 0
5478240 2498520 2498520 defendant Whitlok John innholder 600359 600359 Whitlok, John, of Shirbourne, innholder 1
5489692 2501800 2501800 defendant Bronde John innholder 600359 600359 Bronde, John, of Shirbourne, innholder 0
5505163 2506524 2506524 defendant Wyght John baker 600359 600359 Wyght, John, of Shirbourne, baker 1
5513737 2509151 2509151 defendant Barker Thomas husbandman 600359 600359 Barker, Thomas, of Shirbourne, husbandman 0
5532907 2514833 2514833 defendant Tuser or Tufer Richard   600359 600359 Tuser or Tufer, Richard, of Shirbourne, court holder 1
5537990 2516372 2516372 defendant Weldon John yeoman 600359 600359 Weldon, John, of Shirbourne, yeoman 0
5563861 2524039 2524039 defendant Trowbrygge John tucker 600359 600359 Trowbrygge, John, of Shirbourne, tucker 0
5576777 2527780 2527780 defendant Dene William husbandman 600359 600359 Dene, William, of Shirbourne, husbandman 0

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);