names

59 rows where place_id = 654876

✎ 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
3934079 2001692 2001692 defendant Martyn John merchant 654876 654876 Martyn, John, of Southampton, Hants, merchant 0
4670749 2256528 2256528 defendant Salesbury William husbandman 654876 654876 Salesbury, William, of Southampton, Hants, husbandman 2
4671131 2256635 2256635 defendant Gyffard William clerk 654876 654876 Gyffard, William, of Southampton, Hants, clerk 0
4675077 2257814 2257814 defendant Couper Robert cooper 654876 654876 Couper, Robert, of Southampton, Hants, cooper 0
4683487 2260435 2260435 defendant Rengall Thomas merchant 654876 654876 Rengall, Thomas, of Southampton, Hants, merchant 0
4696446 2264364 2264364 defendant Chamberleyn Robert gent 654876 654876 Chamberleyn, Robert, of Southampton, Hants, gent 2
4709266 2268266 2268266 defendant Rygoll Thomas merchant 654876 654876 Rygoll, Thomas, of Southampton, Hants, merchant 0
4717539 2270820 2270820 defendant Tyer John merchant 654876 654876 Tyer, John, of Southampton, Hants, merchant 0
4720763 2271825 2271825 defendant Caldebek William merchant 654876 654876 Caldebek, William, of Southampton, Hants, merchant 0
4728924 2274285 2274285 defendant Swathelyng Nicholas butcher 654876 654876 Swathelyng, Nicholas, of Southampton, Hants, butcher 0
4742773 2278393 2278393 defendant Chamberlayn Robert esq 654876 654876 Chamberlayn, Robert, of Southampton, Hants, esq 0
4743543 2278640 2278640 defendant Huge John husbandman 654876 654876 Huge, John, of Southampton, Hants, husbandman 2
4743551 2278641 2278641 defendant Huge John husbandman 654876 654876 Huge, John, of Southampton, Hants, husbandman 2
4744666 2278960 2278960 defendant Welefedde John yeoman 654876 654876 Welefedde, John, of Southampton, Hants, yeoman 0
4747518 2279779 2279779 defendant Somersete John butcher 654876 654876 Somersete, John, of Southampton, Hants, butcher 1
4756758 2282478 2282478 defendant Bal William tailor 654876 654876 Bal, William, of Southampton, Hants, tailor 0
4765985 2285352 2285352 defendant Huge John clerk 654876 654876 Huge, John, of Southampton, Hants, clerk 0
4770132 2286627 2286627 defendant Balle Thomas draper 654876 654876 Balle, Thomas, of Southampton, Hants, draper 0
4808019 2298685 2298685 defendant Payne Drugo or Drew gent 654876 654876 Payne, Drugo or Drew, of Southampton, Hants, gent 0
4819196 2302083 2302083 defendant Nicoll William merchant 654876 654876 Nicoll, William, of Southampton, Hants, merchant 2
4819823 2302273 2302273 defendant Waas John laborer 654876 654876 Waas, John, of Southampton, Hants, laborer 0
4837609 2307695 2307695 defendant Daunebury John draper 654876 654876 Daunebury, John, of Southampton, Hants, draper 2
4845823 2310204 2310204 defendant Bentam John merchant 654876 654876 Bentam, John, of Southampton, Hants, merchant 0
4846445 2310394 2310394 defendant Rederham William merchant 654876 654876 Rederham, William, of Southampton, Hants, merchant 0
4846448 2310395 2310395 defendant Rederham William merchant 654876 654876 Rederham, William, of Southampton, Hants, merchant 0
4851969 2312049 2312049 defendant Wodeford John merchant 654876 654876 Wodeford, John, of Southampton, Hants, merchant 0
4853645 2312558 2312558 defendant Wodeford John merchant 654876 654876 Wodeford, John, of Southampton, Hants, merchant 0
4913695 2330782 2330782 defendant Spynell Andrew merchant 654876 654876 Spynell, Andrew, of Southampton, Hants, merchant 0
4913699 2330784 2330784 defendant Spynell Andrew merchant 654876 654876 Spynell, Andrew, of Southampton, Hants, merchant 0
4916365 2331620 2331620 defendant Bowbrok Lawrence merchant 654876 654876 Bowbrok, Lawrence, of Southampton, Hants, merchant 1
4919267 2332536 2332536 defendant Longe Matild widow 654876 654876 Longe, Matild, of Southampton, Hants, widow 2
4933257 2336793 2336793 defendant Gylet Nicholas merchant 654876 654876 Gylet, Nicholas, of Southampton, Hants, merchant 0
4985610 2352613 2352613 defendant Clement John merchant 654876 654876 Clement, John, of Southampton, Hants, merchant 0
4986314 2352832 2352832 defendant Baker Robert husbandman 654876 654876 Baker, Robert, of Southampton, Hants, husbandman 0
4988602 2353548 2353548 defendant Bentham John merchant 654876 654876 Bentham, John, of Southampton, Hants, merchant 0
4988610 2353550 2353550 defendant Bentam John merchant 654876 654876 Bentam, John, of Southampton, Hants, merchant 0
4991505 2354342 2354342 defendant Whatson Thomas   654876 654876 Whatson, Thomas, of Southampton, Hants, servant 0
5000667 2357068 2357068 defendant Clement John merchant 654876 654876 Clement, John, of Southampton, Hants, merchant 0
5007163 2358984 2358984 defendant Clement John merchant 654876 654876 Clement, John, of Southampton, Hants, merchant 0
5131506 2395697 2395697 defendant James Andrew merchant 654876 654876 James, Andrew, of Southampton, Hants, merchant 0
5132031 2395857 2395857 defendant James Andrew merchant 654876 654876 James, Andrew, of Southampton, Hants, merchant 0
5143747 2399302 2399302 defendant Ravyn Thomas merchant 654876 654876 Ravyn, Thomas, of Southampton, Hants, merchant 0
5151630 2401632 2401632 defendant James Andrew merchant 654876 654876 James, Andrew, of Southampton, Hants, merchant 0
5164856 2405454 2405454 defendant Ravyn Thomas merchant 654876 654876 Ravyn, Thomas, of Southampton, Hants, merchant 0
5168769 2406595 2406595 defendant Willyam John   654876 654876 Willyam, John, of Southampton, Hants, burgess & merchant 1
5178402 2409391 2409391 defendant Ravyn Thomas merchant 654876 654876 Ravyn, Thomas, of Southampton, Hants, merchant 0
5208395 2418179 2418179 defendant Whyte Thomas merchant & burgess 654876 654876 Whyte, Thomas, of Southampton, Hants, merchant & burgess 0
5369537 2466059 2466059 defendant Lathom John gent 654876 654876 Lathom, John, of Southampton, Hants, gent 19
5377065 2468416 2468416 defendant Everard John sheer man 654876 654876 Everard, John, of Southampton, Hants, sheer man 3
5389366 2472005 2472005 defendant Underwode Richard merchant 654876 654876 Underwode, Richard, of Southampton, Hants, merchant 0
5412966 2478820 2478820 defendant Lathom John gent 654876 654876 Lathom, John, of Southampton, Hants, gent 17
5418553 2480476 2480476 defendant Bache Thomas fuller 654876 654876 Bache, Thomas, of Southampton, Hants, fuller 0
5436506 2485853 2485853 defendant Bache Thomas fuller 654876 654876 Bache, Thomas, of Southampton, Hants, fuller 0
5436509 2485854 2485854 defendant Bache Thomas fuller 654876 654876 Bache, Thomas, of Southampton, Hants, fuller 0
5444725 2488320 2488320 defendant Pessyn John merchant 654876 654876 Pessyn, John, of Southampton, Hants, merchant 0
5463778 2494083 2494083 defendant Pessyn John merchant 654876 654876 Pessyn, John, of Southampton, Hants, merchant 0
5463785 2494084 2494084 defendant Pessyn John merchant 654876 654876 Pessyn, John, of Southampton, Hants, merchant 0
5467476 2495210 2495210 defendant Kebyll Richard mercer 654876 654876 Kebyll, Richard, of Southampton, Hants, mercer 0
5469850 2495909 2495909 defendant Kibill Richard mercer 654876 654876 Kibill, Richard, of Southampton, Hants, mercer 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);