names

51 rows where place_id = 596146

✎ 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
3623336 1874829 1874829 defendant Wylt Richard butcher 596146 596146 Wylt, Richard, of Axbrygge, butcher 1
3726164 1934449 1934449 defendant Bould Thomas miller 596146 596146 Bould, Thomas, of Axbrygge, miller 0
3726165 1934449 1934449 defendant Currey Richard baker 596146 596146 Currey, Richard, of Axbrygge, baker 1
3761641 1945654 1945654 defendant Turbell or Turvell John husbandman 596146 596146 Turbell or Turvell, John, of Axbrygge, husbandman 0
3761643 1945655 1945655 defendant Turvell John husbandman 596146 596146 Turvell, John, of Axbrygge, husbandman 0
3859582 1976697 1976697 defendant Payne John innholder 596146 596146 Payne, John, of Axbrygge, innholder 0
3859583 1976697 1976697 defendant Whelar Thomas yeoman 596146 596146 Whelar, Thomas, of Axbrygge, yeoman 1
4515737 2205349 2205349 plaintiff Clerk Stephen   596146 596146 Clerk, Stephen, of Axbrygge 0
4689600 2262306 2262306 defendant Baker Nicholas baker 596146 596146 Baker, Nicholas, of Axbrygge, baker 1
4793866 2294205 2294205 defendant Barbour John barber 596146 596146 Barbour, John, of Axbrygge, barber 0
4834022 2306646 2306646 defendant Wygmore John dyer 596146 596146 Wygmore, John, of Axbrygge, dyer 1
4978138 2350426 2350426 defendant Beny John weaver 596146 596146 Beny, John, of Axbrygge, weaver 3
4985325 2352530 2352530 plaintiff Yevan John   596146 596146 Yevan, John, of Axbrygge 0
5020505 2362886 2362886 defendant Gryce John tucker 596146 596146 Gryce, John, of Axbrygge, tucker 1
5020510 2362886 2362886 defendant Smok Richard mercer 596146 596146 (Smok, Richard, of Axbrygge, mercer 6
5025367 2364315 2364315 defendant Barton William tanner 596146 596146 Barton, William, of Axbrygge, tanner 0
5031629 2366113 2366113 defendant Crudmede John dyer 596146 596146 Crudmede, John, of Axbrygge, dyer 3
5069613 2377408 2377408 defendant Gryse John fuller 596146 596146 Gryse, John, of Axbrygge, fuller 2
5069614 2377408 2377408 defendant Hayne John fuller 596146 596146 Hayne, John, of Axbrygge, fuller 3
5084681 2381933 2381933 defendant Clerk William tanner 596146 596146 Clerk, William, of Axbrygge, tanner 0
5089729 2383371 2383371 defendant Pryce William mercer 596146 596146 Pryce, William, of Axbrygge, mercer 0
5089730 2383371 2383371 defendant Smoke Thomas draper 596146 596146 Smoke, Thomas, of Axbrygge, draper 1
5093958 2384629 2384629 defendant Phelpys John tailor 596146 596146 Phelpys, John, of Axbrygge, tailor 1
5097044 2385567 2385567 defendant Payn John mercer 596146 596146 Payn, John, of Axbrygge, mercer 3
5113430 2390322 2390322 defendant Ingram John yeoman 596146 596146 Ingram, John, of Axbrygge, yeoman 0
5131488 2395693 2395693 defendant Hayne John merchant 596146 596146 Hayne, John, of Axbrygge, merchant 0
5132397 2395972 2395972 defendant Forste John chapman 596146 596146 Forste, John, of Axbrygge, chapman 3
5139881 2398142 2398142 defendant Fysean William weaver 596146 596146 Fysean, William, of Axbrygge, weaver 0
5139883 2398143 2398143 defendant Glover William weaver 596146 596146 Glover, William, of Axbrygge, weaver 0
5152585 2401895 2401895 defendant Heyne John fuller 596146 596146 Heyne, John, of Axbrygge, fuller 0
5152587 2401896 2401896 defendant Heyne John fuller 596146 596146 Heyne, John, of Axbrygge, fuller 0
5160889 2404285 2404285 defendant Fysean William weaver 596146 596146 Fysean, William, of Axbrygge, weaver 0
5160891 2404286 2404286 defendant Glover William weaver 596146 596146 Glover, William, of Axbrygge, weaver 0
5169271 2406748 2406748 defendant Hayne John merchant 596146 596146 Hayne, John, of Axbrygge, merchant 0
5170292 2407042 2407042 defendant Heyne John fuller 596146 596146 Heyne, John, of Axbrygge, fuller 0
5185908 2411625 2411625 defendant Hayne John merchant 596146 596146 Hayne, John, of Axbrygge, merchant 0
5201457 2416184 2416184 defendant Aleyn John tanner 596146 596146 Aleyn, John, of Axbrygge, tanner 3
5236210 2426177 2426177 defendant Payn John clothmaker 596146 596146 Payn, John, of Axbrygge, clothmaker 0
5236343 2426219 2426219 defendant Chapman James chapman 596146 596146 Chapman, James, of Axbrygge, chapman 0
5238818 2426941 2426941 defendant Phelps John tailor 596146 596146 Phelps, John, of Axbrygge, tailor 0
5326562 2453026 2453026 defendant Curteys Thomas chapman 596146 596146 Curteys, Thomas, of Axbrygge, chapman 0
5327243 2453219 2453219 defendant Payn Edmund yeoman 596146 596146 Payn, Edmund, of Axbrygge, yeoman 0
5373568 2467331 2467331 defendant Cachemay Thomas fuller of cloth 596146 596146 Cachemay, Thomas, of Axbrygge, fuller of cloth 0
5405658 2476692 2476692 defendant Courteys Thomas merchant 596146 596146 Courteys, Thomas, of Axbrygge, merchant 0
5419758 2480825 2480825 defendant Harres William   596146 596146 Harres, William, of Axbrygge, parish clerk 0
5437422 2486138 2486138 defendant Harres William   596146 596146 Harres, William, of Axbrygge, court holder 0
5438219 2486365 2486365 defendant Harres William   596146 596146 Harres, William, of Axbrygge, court holder or parish clerk 0
5439354 2486704 2486704 defendant Harper Roger fuller 596146 596146 Harper, Roger, of Axbrygge, fuller 0
5439355 2486704 2486704 defendant Fychet John hosier 596146 596146 Fychet, John, of Axbrygge, hosier 1
5439356 2486704 2486704 defendant Shete Thomas baker 596146 596146 Shete, Thomas, of Axbrygge, baker 2
5453208 2490839 2490839 defendant Fychet John hosier 596146 596146 Fychet, John, of Axbrygge, hosier 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);