names

64 rows where place_id = 591920

✎ 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
3605980 1869533 1869533 defendant Chapman Chruistopher tailor 591920 591920 Chapman, Chruistopher, of Terryng, tailor 4
3620364 1873953 1873953 defendant Amberley Roger tailor 591920 591920 Amberley, Roger, of Terryng, tailor 0
3620365 1873953 1873953 defendant Turnageyne John husbandman 591920 591920 Turnageyne, John, of Terryng, husbandman 1
3648091 1909797 1909797 defendant Ryvers John carpenter 591920 591920 Ryvers, John, of Terryng, carpenter 0
3648093 1909797 1909797 defendant Lynsey Thomas shoemaker 591920 591920 Lynsey, Thomas, of Terryng, shoemaker 2
3766984 1947340 1947340 defendant A Wodde John husbandman 591920 591920 A Wodde, John, of Terryng, husbandman 3
3816677 1963119 1963119 defendant Towneley John butcher 591920 591920 Towneley, John, of Terryng, butcher 0
3862807 1977753 1977753 defendant Gyles Thomas laborer 591920 591920 Gyles, Thomas, of Terryng, laborer 0
3892974 1987895 1987895 defendant Weston John husbandman 591920 591920 Weston, John, of Terryng, husbandman 1
3892975 1987895 1987895 defendant Caron Thomas husbandman 591920 591920 Caron, Thomas, of Terryng, husbandman 2
3892976 1987895 1987895 defendant Pratte Edward husbandman 591920 591920 Pratte, Edward, of Terryng, husbandman 3
3914213 1995099 1995099 defendant Adams John husbandman 591920 591920 Adams, John, of Terryng, husbandman 1
4038034 2038249 2038249 plaintiff Kyngston Roger yeoman 591920 591920 Kyngston, Roger, of Terryng, yeoman 0
4563326 2220102 2220102 defendant Bourgh John   591920 591920 Bourgh, John, of Terryng 0
4717674 2270862 2270862 defendant Cuffle Walter yeoman 591920 591920 Cuffle, Walter, of Terryng, yeoman 0
4742363 2278258 2278258 defendant Toper John   591920 591920 Toper, John, of Terryng, millward 2
4757502 2282724 2282724 defendant Holewell Robert husbandman 591920 591920 Holewell, Robert, of Terryng, husbandman 0
4768421 2286095 2286095 defendant Bourgh John husbandman 591920 591920 Bourgh, John, of Terryng, husbandman 0
4775716 2288402 2288402 defendant Smyth Robert smith 591920 591920 Smyth, Robert, of Terryng, smith 0
4867284 2316732 2316732 defendant Wythyer John husbandman 591920 591920 Wythyer, John, of Terryng, husbandman 0
4881539 2321128 2321128 defendant Coupere Richard chapman 591920 591920 Coupere, Richard, of Terryng, chapman 0
4881540 2321128 2321128 defendant Lette Richard butcher 591920 591920 Lette, Richard, of Terryng, butcher 1
4909366 2329468 2329468 defendant Clerk John husbandman 591920 591920 Clerk, John, of Terryng, husbandman 2
4929690 2335703 2335703 defendant Bodyn John husbandman 591920 591920 Bodyn, John, of Terryng, husbandman 0
4951587 2342453 2342453 defendant atte Wode Lawrence plumber 591920 591920 (atte Wode, Lawrence, of Terryng, plumber 3
4997136 2356000 2356000 plaintiff (not given) Roger rector of Heron 591920 591920 Heron, Roger, of Terryng, clerk & rector of the parish church, executors of 0
4997142 2356001 2356001 plaintiff (not given) Roger rector of Heron 591920 591920 Heron, Roger, of Terryng, clerk, rector of the parish church, executors of 0
4997148 2356002 2356002 plaintiff Heron Roger (legal representative) 591920 591920 Heron, Roger, of Terryng, formerly parson, executors of 0
4997154 2356003 2356003 plaintiff (not given) Roger rector of Heron 591920 591920 Heron, Roger, of Terryng, rector of the parish church and master of the college in Maidstone, executors of 0
5015697 2361477 2361477 defendant Hemery Ralph husbandman 591920 591920 Hemery, Ralph, of Terryng, husbandman 0
5023868 2363892 2363892 defendant Bodyn John husbandman 591920 591920 Bodyn, John, of Terryng, husbandman 0
5023869 2363892 2363892 defendant Clerk John chaplain 591920 591920 Clerk, John, of Terryng, chaplain 1
5023871 2363892 2363892 defendant Lette or Lotte Richard butcher 591920 591920 Lette or Lotte, Richard, of Terryng, butcher 3
5090820 2383705 2383705 defendant Frenssh Robert sherman 591920 591920 Frenssh, Robert, of Terryng, sherman 1
5115171 2390859 2390859 defendant Frenssh Robert sherman 591920 591920 Frenssh, Robert, of Terryng, sherman 0
5151337 2401541 2401541 defendant Hogge William tailor 591920 591920 Hogge, William, of Terryng, tailor 0
5169511 2406821 2406821 defendant Hogge William tailor 591920 591920 Hogge, William, of Terryng, tailor 0
5190093 2412845 2412845 defendant Adam Richard husbandman 591920 591920 Adam, Richard, of Terryng, husbandman 0
5257034 2432328 2432328 defendant Yong John mercer 591920 591920 Yong, John, of Terryng, mercer 0
5263622 2434372 2434372 defendant Yonge John chapman 591920 591920 Yonge, John, of Terryng, chapman 0
5266348 2435228 2435228 defendant Jenyn John husbandman 591920 591920 Jenyn, John, of Terryng, husbandman 0
5266349 2435228 2435228 defendant Penyale John husbandman 591920 591920 Penyale, John, of Terryng, husbandman 1
5291069 2442390 2442390 defendant Jenyng John   591920 591920 Jenyng, John, of Terryng, servant 1
5312969 2448909 2448909 defendant Yong John chapman 591920 591920 Yong, John, of Terryng, chapman 0
5376616 2468284 2468284 defendant Penyale Richard husbandman 591920 591920 Penyale, Richard, of Terryng, husbandman 0
5469845 2495909 2495909 defendant Apowell Roger tailor 591920 591920 Apowell, Roger, of Terryng, tailor 1
5481164 2499320 2499320 defendant Grene John, junior yeoman 591920 591920 Grene, John, junior, of Terryng, yeoman 0
5481165 2499320 2499320 defendant Andymer John esq 591920 591920 Andymer, John, of Terryng, esq 1
5481167 2499321 2499321 defendant Grene John, junior yeoman 591920 591920 Grene, John, junior, of Terryng, yeoman 0
5481168 2499321 2499321 defendant Andymer John esq 591920 591920 Andymer, John, of Terryng, esq 1
5516245 2509918 2509918 defendant Stamer Philip yeoman 591920 591920 Stamer, Philip, of Terryng, yeoman 0
5523070 2512040 2512040 defendant Kyngeston Thomas smith 591920 591920 Kyngeston, Thomas, of Terryng, smith 1
5537681 2516274 2516274 defendant Grene John yeoman or gent 591920 591920 Grene, John, of Terryng, yeoman or gent 2
5537682 2516274 2516274 defendant Hene Philip gent 591920 591920 Hene, Philip, of Terryng, gent 3
5537683 2516274 2516274 defendant Marche Nicholas yeoman 591920 591920 Marche, Nicholas, of Terryng, yeoman 4
5537684 2516274 2516274 defendant Lynster Thomas yeoman 591920 591920 Lynster, Thomas, of Terryng, yeoman 5
5556148 2521792 2521792 defendant Heth John yeoman 591920 591920 Heth, John, of Terryng, yeoman 0
5593470 2532940 2532940 defendant Lynster Thomas tailor 591920 591920 Lynster, Thomas, of Terryng, tailor 1
5596528 2533829 2533829 defendant Kyngeston Thomas smith 591920 591920 Kyngeston, Thomas, of Terryng, smith 2
5610148 2546883 2546883 defendant Saghiere John   591920 591920 Saghiere, John, of Terryng 0
5611423 2547305 2547305 plaintiff Borlee John de (legal representative) 591920 591920 Borlee, John de, of Terryng, formerly parson of the church, executors of 0
5611426 2547305 2547305 plaintiff Dykes Robert   591920 591920 Dykes, Robert, of Terryng, vicar 3
5623945 2551436 2551436 defendant Bakere Ralph smith 591920 591920 Bakere, Ralph, of Terryng, smith 1
5625301 2551851 2551851 defendant Smyth Robert smith 591920 591920 Smyth, Robert, of Terryng, smith 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);