names

53 rows where place_id = 666699

✎ 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
3982083 2018351 2018351 defendant Fortescue Henry gent 666699 666699 Fortescue, Henry, of Kingston, gent 0
3982084 2018351 2018351 defendant Peter Richard laborer 666699 666699 Peter, Richard, of Kingston, laborer 1
4008823 2027917 2027917 plaintiff Morse John   666699 666699 Morse, John, of Kingston, mason 0
4095995 2058897 2058897 defendant Bisshope Richard yeoman 666699 666699 Bisshope, Richard, of Kingston, yeoman 1
4096154 2058953 2058953 defendant Baye John, junior husbandman 666699 666699 Baye, John, junior, of Kingston, husbandman 0
4105115 2062102 2062102 defendant Grene William husbandman or yeoman 666699 666699 Grene, William, of Kingston, husbandman or yeoman 0
4115287 2065758 2065758 defendant Bisshope Richard yeoman 666699 666699 Bisshope, Richard, of Kingston, yeoman 1
4137364 2073713 2073713 defendant Bult William husbandman 666699 666699 Bult, William, of Kingston, husbandman 1
4138626 2074181 2074181 defendant Bult William husbandman 666699 666699 Bult, William, of Kingston, husbandman 1
4148466 2077592 2077592 defendant Vicarey John husbandman 666699 666699 Vicarey, John, of Kingston, husbandman 2
4178924 2088106 2088106 defendant ap Rotheraughe Maurice laborer 666699 666699 ap Rotheraughe, Maurice, of Kingston, laborer 2
4210327 2099166 2099166 defendant Bult William husbandman 666699 666699 Bult, William, of Kingston, husbandman 1
4214771 2100672 2100672 defendant Hardman William yeoman 666699 666699 Hardman, William, of Kingston, yeoman 0
4216963 2101427 2101427 defendant Randall or Rundell Robert husbandman 666699 666699 Randall or Rundell, Robert, of Kingston, husbandman 0
4216964 2101427 2101427 defendant Perrys John husbandman 666699 666699 Perrys, John, of Kingston, husbandman 1
4225051 2104231 2104231 defendant Gobye Henry husbandman 666699 666699 Gobye, Henry, of Kingston, Wymborn Mynster, husbandman 1
4225436 2104361 2104361 defendant Martyn Nicholas yeoman 666699 666699 Martyn, Nicholas, of Kingston, yeoman 0
4233711 2107313 2107313 defendant Martyn Nicholas yeoman 666699 666699 Martyn, Nicholas, of Kingston, yeoman 0
4241906 2110284 2110284 defendant Clarke Thomas yeoman 666699 666699 Clarke, Thomas, of Kingston, yeoman 0
4277936 2122212 2122212 defendant Barton Stephen gent 666699 666699 Barton, Stephen, of Kingston, gent 1
4293122 2127606 2127606 defendant Spencer John yeoman 666699 666699 Spencer, John, of Kingston, yeoman 0
4306119 2132279 2132279 defendant Cole John husbandman 666699 666699 Cole, John, of Kingston, husbandman 2
4312881 2134632 2134632 defendant Cowper Edmund merchant 666699 666699 Cowper, Edmund, of Kingston, merchant 0
4329364 2140132 2140132 defendant Graye Christopher esq 666699 666699 Graye, Christopher, of Kingston, esq 0
4358314 2150144 2150144 defendant Lowman John gent 666699 666699 Lowman, John, of Kingston, gent 0
4361402 2151241 2151241 defendant Gobye Thomas husbandman 666699 666699 Gobye, Thomas, of Kingston, Wymborne Mynster, husbandman 0
4361519 2151280 2151280 defendant Combe Walter tanner 666699 666699 Combe, Walter, of Kingston, tanner 0
4363003 2151831 2151831 defendant Streete Philip clerk 666699 666699 Streete, Philip, of Kingston, clerk 0
4380154 2158006 2158006 defendant Hardman William butcher 666699 666699 Hardman, William, of Kingston, butcher 0
4397318 2163682 2163682 defendant Hill Richard gent 666699 666699 Hill, Richard, of Kingston, gent 0
4399639 2164469 2164469 defendant Howell Hugh husbandman 666699 666699 Howell, Hugh, of Kingston, husbandman 0
4408487 2167420 2167420 defendant Strete Philip clerk 666699 666699 Strete, Philip, of Kingston, clerk 0
4411339 2168381 2168381 defendant Lovatt John yeoman 666699 666699 Lovatt, John, of Kingston, or of Callowehill, yeoman 1
4743776 2278708 2278708 defendant Herdy John shipman 666699 666699 Herdy, John, of Kingston, shipman 3
4743777 2278708 2278708 defendant Merflete John mariner 666699 666699 Merflete, John, of Kingston, mariner 4
4764320 2284836 2284836 plaintiff Dalston Nicholas   666699 666699 Dalston, Nicholas, of Kingston 2
4786959 2291985 2291985 defendant Priour John soaper 666699 666699 Priour, John, of Kingston, soaper 0
4798716 2295776 2295776 defendant Denton William husbandman 666699 666699 Denton, William, of Kingston, husbandman 0
4800758 2296422 2296422 defendant Kyghley John chapman 666699 666699 Kyghley, John, of Kingston, chapman 0
4811884 2299830 2299830 defendant Tredewey John clerk 666699 666699 Tredewey, John, of Kingston, clerk 1
4837558 2307681 2307681 defendant Barton Thomas chaplain 666699 666699 Barton, Thomas, of Kingston, chaplain 2
4839952 2308408 2308408 defendant Dalston Nicholas merchant 666699 666699 Dalston, Nicholas, of Kingston, merchant 2
4846654 2310463 2310463 defendant Britby William merchant 666699 666699 Britby, William, of Kingston, merchant 1
4846655 2310463 2310463 defendant Tutbury Lawrence merchant 666699 666699 Tutbury, Lawrence, of Kingston, merchant 2
4846656 2310463 2310463 defendant Barton Thomas merchant 666699 666699 together with Barton, Thomas, of Kingston, merchant 3
4995976 2355646 2355646 defendant Redmer Robert merchant 666699 666699 Redmer, Robert, of Kingston, merchant 1
5039005 2368312 2368312 defendant Ryplay William merchant 666699 666699 (Ryplay, William, of Kingston, merchant 2
5048064 2371044 2371044 defendant Brewith Richard   666699 666699 Brewith, Richard, of Kingston, tallow chandler 1
5141268 2398566 2398566 defendant Katerynson William mariner 666699 666699 Katerynson, William, of Kingston, mariner 1
5409065 2477677 2477677 defendant Swyneshed William tailor 666699 666699 Swyneshed, William, of Kingston, tailor 2
5409067 2477677 2477677 defendant Best Robert carpenter 666699 666699 Best, Robert, of Kingston, carpenter 4
5409068 2477677 2477677 defendant Brampton William laborer 666699 666699 Brampton, William, of Kingston, laborer 5
5409069 2477677 2477677 defendant Breggeman John   666699 666699 Breggeman, John, of Kingston 6

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