names

67 rows where place_id = 585957

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587568 1863759 1863759 defendant Swete John (legal representative) 585957 585957 Swete, John, of Neuton Busshell, executrix of 0
3587569 1863759 1863759 defendant Swete Joan widow 585957 585957 Swete, Joan, of Neuton Busshell, widow 1
3589850 1864466 1864466 defendant Donwyll William tanner 585957 585957 Donwyll, William, of Neuton Busshell, tanner 2
3590068 1864535 1864535 defendant Thorne John tanner 585957 585957 Thorne, John, of Neuton Busshell, tanner 0
3590069 1864535 1864535 defendant Meryfeld Thomas tanner 585957 585957 Meryfeld, Thomas, of Neuton Busshell, tanner 1
3590070 1864535 1864535 defendant Colyns John smith 585957 585957 Colyns, John, of Neuton Busshell, smith 2
3593446 1865584 1865584 defendant Merefeld Gervase yeoman 585957 585957 Merefeld, Gervase, of Neuton Busshell, yeoman 0
4869454 2317416 2317416 defendant Ware John yeoman 585957 585957 Ware, John, of Neuton Busshell, yeoman 0
4873831 2318754 2318754 defendant Hakeworth Robert carpenter 585957 585957 Hakeworth, Robert, of Neuton Busshell, carpenter 2
4933348 2336816 2336816 defendant Gamlyn John husbandman 585957 585957 Gamlyn, John, of Neuton Busshell, husbandman 0
4960428 2345083 2345083 defendant Penell Walter tanner 585957 585957 Penell, Walter, of Neuton Busshell, tanner 1
4963233 2345911 2345911 defendant Baggetor John turner 585957 585957 Baggetor, John, of Neuton Busshell, turner 0
4971090 2348295 2348295 defendant Bysshop William gent 585957 585957 Bysshop, William, of Neuton Busshell, gent 0
4971585 2348431 2348431 defendant Swete John mercer 585957 585957 Swete, John, of Neuton Busshell, mercer 2
5014303 2361037 2361037 defendant Byllyk John chaplain 585957 585957 Byllyk, John, of Neuton Busshell, chaplain 0
5021895 2363297 2363297 defendant Knyght Richard   585957 585957 Knyght, Richard, of Neuton Busshell, cook 1
5045861 2370397 2370397 defendant Sayer John mercer 585957 585957 Sayer, John, of Neuton Busshell, mercer 0
5068364 2377039 2377039 defendant Molton Walter glover 585957 585957 Molton, Walter, of Neuton Busshell, glover 1
5069004 2377225 2377225 defendant Pomeray Vincent chapman 585957 585957 Pomeray, Vincent, of Neuton Busshell, chapman 0
5123546 2393340 2393340 defendant Jacawe Thomas merchant 585957 585957 Jacawe, Thomas, of Neuton Busshell, or of Dertemouthe, merchant 0
5210793 2418888 2418888 defendant Bolworthy William butcher 585957 585957 Bolworthy, William, of Neuton Busshell, butcher 0
5212467 2419390 2419390 defendant Thomme John   585957 585957 Thomme, John, of Neuton Busshell, "fyssheionter" 0
5212475 2419392 2419392 defendant Thomme John   585957 585957 Thomme, John, of Neuton Busshell, "fyssheionter" 0
5217870 2420958 2420958 defendant Steur John butcher 585957 585957 Steur, John, of Neuton Busshell, butcher 1
5237411 2426526 2426526 defendant Baketor Joan widow 585957 585957 (Baketor, Joan, of Neuton Busshell, widow 1
5271155 2436660 2436660 defendant Bytcombe John tailor 585957 585957 Bytcombe, John, of Neuton Busshell, tailor 0
5284542 2440490 2440490 defendant Bytcombe John tailor 585957 585957 Bytcombe, John, of Neuton Busshell, tailor 0
5312977 2448912 2448912 defendant Luton Maurice merchant 585957 585957 Luton, Maurice, of Neuton Busshell, merchant 1
5312978 2448912 2448912 defendant Strete Philip merchant 585957 585957 Strete, Philip, of Neuton Busshell, merchant 2
5317706 2450386 2450386 defendant Luton Roger smith 585957 585957 Luton, Roger, of Neuton Busshell, smith 0
5318308 2450574 2450574 defendant Luveton Roger merchant 585957 585957 Luveton, Roger, of Neuton Busshell, merchant 0
5318311 2450574 2450574 defendant Whitchurch William yeoman 585957 585957 Whitchurch, William, of Neuton Busshell, yeoman 3
5321490 2451519 2451519 defendant Bagetor John husbandman 585957 585957 Bagetor, John, of Neuton Busshell, husbandman 0
5321491 2451519 2451519 defendant Holbem John cordwainer 585957 585957 Holbem, John, of Neuton Busshell, cordwainer 1
5321760 2451581 2451581 defendant Hauke or Hanke William tucker 585957 585957 Hauke or Hanke, William, of Neuton Busshell, tucker 2
5321761 2451581 2451581 defendant Jacobbe Thomas tanner 585957 585957 Jacobbe, Thomas, of Neuton Busshell, tanner 3
5321764 2451582 2451582 defendant Fyncent Richard merchant 585957 585957 Fyncent, Richard, of Neuton Busshell, merchant 0
5330463 2454192 2454192 defendant Alyn John tailor 585957 585957 Alyn, John, of Neuton Busshell, tailor 0
5330464 2454192 2454192 defendant Perse William dyer 585957 585957 Perse, William, of Neuton Busshell, dyer 1
5338868 2456731 2456731 defendant Strete Philip merchant 585957 585957 Strete, Philip, of Neuton Busshell, merchant 0
5338870 2456732 2456732 defendant Strete Philip merchant 585957 585957 Strete, Philip, of Neuton Busshell, merchant 0
5339372 2456884 2456884 defendant Luneton or Limeton Roger merchant 585957 585957 Luneton or Limeton, Roger, of Neuton Busshell, merchant 0
5339373 2456884 2456884 defendant Strete Philip sherman 585957 585957 Strete, Philip, of Neuton Busshell, sherman 1
5341385 2457497 2457497 defendant Pope John merchant 585957 585957 Pope, John, of Neuton Busshell, merchant 0
5356305 2462046 2462046 defendant Mate Thomas smith 585957 585957 Mate, Thomas, of Neuton Busshell, smith 3
5357291 2462344 2462344 defendant Luton Roger merchant 585957 585957 Luton, Roger, of Neuton Busshell, merchant 0
5357292 2462344 2462344 defendant Luton Maurice merchant 585957 585957 Luton, Maurice, of Neuton Busshell, merchant 1
5364843 2464669 2464669 defendant Bytcombe John yeoman 585957 585957 Bytcombe, John, of Neuton Busshell, yeoman 0
5367965 2465605 2465605 defendant Gurnay Thomas yeoman 585957 585957 Gurnay, Thomas,of Neuton Busshell, yeoman 0
5373476 2467299 2467299 defendant Leveton Roger merchant 585957 585957 Leveton, Roger, of Neuton Busshell, merchant 0
5375155 2467817 2467817 defendant Aleyn John yeoman 585957 585957 Aleyn, John, of Neuton Busshell, yeoman 1
5376092 2468112 2468112 defendant Luton Roger merchant 585957 585957 Luton, Roger, of Neuton Busshell, merchant 0
5395081 2473661 2473661 defendant Frenssh John tanner 585957 585957 Frenssh, John, of Neuton Busshell, tanner 0
5415431 2479552 2479552 defendant Frenssh John tanner 585957 585957 Frenssh, John, of Neuton Busshell, tanner 0
5431656 2484428 2484428 defendant Frenssh John   585957 585957 Frenssh, John, of Neuton Busshell 0
5431658 2484429 2484429 defendant Frenssh John tanner 585957 585957 Frenssh, John, of Neuton Busshell, tanner 0
5431660 2484430 2484430 defendant Frensshe John tanner 585957 585957 Frensshe, John, of Neuton Busshell, tanner 0
5477906 2498416 2498416 defendant Bytcombe John yeoman 585957 585957 Bytcombe, John, of Neuton Busshell, yeoman 0
5482600 2499735 2499735 defendant Meryfeld Gervase yeoman 585957 585957 Meryfeld, Gervase, of Neuton Busshell, yeoman 1
5483112 2499888 2499888 defendant Strete Philip yeoman 585957 585957 Strete, Philip, of Neuton Busshell, yeoman 1
5501929 2505528 2505528 defendant Meryfeld Gervase yeoman 585957 585957 Meryfeld, Gervase, of Neuton Busshell, yeoman 0
5501931 2505529 2505529 defendant Vyncent Peter yeoman 585957 585957 Vyncent, Peter, of Neuton Busshell, yeoman 0
5511341 2508391 2508391 defendant Vyncent Peter yeoman 585957 585957 Vyncent, Peter, of Neuton Busshell, yeoman 0
5517899 2510442 2510442 defendant Jacob John baker 585957 585957 Jacob, John, of Neuton Busshell, baker 0
5520120 2511117 2511117 defendant Fryer John baker 585957 585957 Fryer, John, of Neuton Busshell, baker 0
5521794 2511632 2511632 defendant Mayne John yeoman 585957 585957 Mayne, John, of Neuton Busshell, yeoman 0
5636688 2555420 2555420 defendant Stonyng John tailor 585957 585957 Stonyng, John, of Neuton Busshell, tailor 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);