names

50 rows where place_id = 756620

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4439354 2181576 2181576 defendant Gosselyn Eustace   756620 756620 Gosselyn, Eustace, of Kymberle 3
4579027 2224920 2224920 defendant Rylyng Julia   756620 756620 Rylyng, Julia, of Kymberle 3
4585309 2226827 2226827 defendant Calye John   756620 756620 Calye, John, of Kymberle 0
4604203 2232485 2232485 defendant Cros John   756620 756620 Cros, John, of Kymberle 0
4634963 2241782 2241782 defendant Joye John   756620 756620 Joye, John, of Kymberle 0
4639141 2242965 2242965 defendant Caly John   756620 756620 Caly, John, of Kymberle 0
4647268 2245256 2245256 plaintiff Curson John   756620 756620 Curson, John, of Kymberle 1
4647273 2245257 2245257 plaintiff Curson John   756620 756620 Curson, John, of Kymberle 1
4742020 2278165 2278165 defendant Turnour John husbandman 756620 756620 Turnour, John, of Kymberle, husbandman 0
4809476 2299137 2299137 defendant Chamberleyn Ralph yeoman 756620 756620 Chamberleyn, Ralph, of Kymberle, yeoman 2
4849213 2311228 2311228 defendant Thurton Simon gent 756620 756620 Thurton, Simon, of Kymberle, gent 0
4871372 2318016 2318016 plaintiff Middelton John   756620 756620 Middelton, John, of Kymberle 0
4871374 2318017 2318017 plaintiff Middelton John   756620 756620 Middelton, John, of Kymberle 0
4885036 2322215 2322215 defendant Joye John (legal representative) 756620 756620 Joye, John, of Kymberle, executor of 0
4885037 2322215 2322215 defendant Marleworth William clerk 756620 756620 Marleworth, William, of Kymberle, clerk 1
4885265 2322281 2322281 defendant North Richard   756620 756620 North, Richard, of Kymberle 0
4911036 2329963 2329963 defendant Fraunceys William yeoman 756620 756620 Fraunceys, William, of Kymberle, yeoman 0
4930920 2336067 2336067 defendant Fraunceys William husbandman 756620 756620 Fraunceys, William, of Kymberle, husbandman 7
4955041 2343459 2343459 defendant Middelton John laborer 756620 756620 Middelton, John, of Kymberle, laborer 1
4996887 2355926 2355926 defendant Elsyng John husbandman 756620 756620 Elsyng, John, of Kymberle, husbandman 8
5022164 2363372 2363372 defendant Wodehous John esq 756620 756620 Wodehous, John, of Kymberle, esq 1
5036053 2367400 2367400 defendant Alpe Robert butcher 756620 756620 Alpe, Robert, of Kymberle, butcher 4
5036056 2367400 2367400 defendant Fraunceys William, junior husbandman 756620 756620 Fraunceys, William, junior, of Kymberle, husbandman 7
5036062 2367401 2367401 defendant Fraunceys William, junior yeoman 756620 756620 Fraunceys, William, junior, of Kymberle, yeoman 3
5037820 2367939 2367939 defendant Alpe Robert butcher 756620 756620 Alpe, Robert, of Kymberle, butcher 0
5069268 2377296 2377296 defendant Marleburgh William clerk 756620 756620 Marleburgh, William, of Kymberle, clerk 0
5079850 2380450 2380450 defendant Wyghtman Henry husbandman 756620 756620 Wyghtman, Henry, of Kymberle, husbandman:Oldman, William, of Kymberle, husbandman 1
5095962 2385248 2385248 defendant Kyng Richard husbandman 756620 756620 Kyng, Richard, of Kymberle, husbandman 3
5136867 2397305 2397305 defendant Fysshe William yeoman 756620 756620 Fysshe, William, of Kymberle, yeoman 1
5142956 2399066 2399066 defendant Fysshe William husbandman 756620 756620 Fysshe, William, of Kymberle, husbandman 0
5154705 2402531 2402531 defendant Alre Thomas husbandman 756620 756620 Alre, Thomas, of Kymberle, husbandman 0
5154706 2402531 2402531 defendant Fyssh Thomas husbandman 756620 756620 Fyssh, Thomas, of Kymberle, husbandman 1
5157436 2403312 2403312 defendant Fysshe William yeoman 756620 756620 Fysshe, William, of Kymberle, yeoman 1
5171660 2407431 2407431 defendant Alpe Thomas husbandman 756620 756620 Alpe, Thomas, of Kymberle, husbandman 2
5171661 2407431 2407431 defendant Fysshe Thomas husbandman 756620 756620 Fysshe, Thomas, of Kymberle, husbandman 3
5173358 2407916 2407916 defendant Fyssh William yeoman 756620 756620 Fyssh, William, of Kymberle, yeoman 1
5178303 2409356 2409356 defendant Bonde Nicholas baker 756620 756620 Bonde, Nicholas, of Kymberle, baker 1
5201393 2416162 2416162 defendant Bonde Nicholas baker 756620 756620 Bonde, Nicholas, of Kymberle, baker 1
5206866 2417744 2417744 defendant Alpe Thomas husbandman 756620 756620 Alpe, Thomas, of Kymberle, husbandman 0
5206867 2417744 2417744 defendant Fyssh Thomas husbandman 756620 756620 Fyssh, Thomas, of Kymberle, husbandman 1
5225925 2423254 2423254 defendant Alpe Simon laborer 756620 756620 Alpe, Simon, of Kymberle, laborer 1
5228962 2424075 2424075 defendant Byrd Richard husbandman 756620 756620 Byrd, Richard, of Kymberle, husbandman 0
5237092 2426434 2426434 defendant Wyghtman Henry husbandman 756620 756620 Wyghtman, Henry, of Kymberle, husbandman 0
5237373 2426516 2426516 plaintiff Fytlyng John   756620 756620 Fytlyng, John, of Kymberle 0
5247514 2429424 2429424 defendant Curson Robert husbandman 756620 756620 Curson, Robert, of Kymberle, husbandman 7
5255546 2431851 2431851 defendant Wodehous Edward esq 756620 756620 Wodehous, Edward, of Kymberle, esq 1
5283058 2440106 2440106 defendant Wodhous Edward   756620 756620 Wodhous, Edward, of Kymberle, knight 0
5317492 2450317 2450317 defendant Curson William baker 756620 756620 Curson, William, of Kymberle, baker 0
5318813 2450718 2450718 defendant Curson William baker 756620 756620 Curson, William, of Kymberle, baker 0
5468278 2495453 2495453 defendant Alpe Simon husbandman 756620 756620 Alpe, Simon, of Kymberle, husbandman 1

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