names

56 rows where place_id = 723387

✎ 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
3806136 1959847 1959847 defendant Conyers Richard (legal representative) 723387 723387 Conyers, Richard, of Long Stanton, gent, executrix of 1
4250478 2113146 2113146 defendant Harrys Humphrey yeoman 723387 723387 Harrys, Humphrey, of Long Stanton, yeoman 0
4294464 2128105 2128105 defendant Boston George yeoman 723387 723387 Boston, George, of Long Stanton, yeoman 0
4296553 2128868 2128868 defendant Boston George yeoman 723387 723387 Boston, George, of Long Stanton, yeoman 0
4324367 2138546 2138546 defendant Boston George yeoman 723387 723387 Boston, George, of Long Stanton, yeoman 1
4418990 2170805 2170805 plaintiff Cundy Robert chaplain 723387 723387 Cundy, Robert, of Long Stanton, chaplain 1
4638591 2242824 2242824 defendant Page atte Grene John   723387 723387 Page atte Grene, John, of Long Stanton 0
4638592 2242824 2242824 defendant Smyth John   723387 723387 Smyth, John, of Long Stanton 1
4671104 2256627 2256627 defendant Fouler Simone yeoman 723387 723387 Fouler, Simone, of Long Stanton, yeoman 0
4675876 2258066 2258066 defendant Foulere Simon husbandman 723387 723387 Foulere, Simon, of Long Stanton, husbandman 0
4677543 2258590 2258590 defendant Foulere Simon husbandman 723387 723387 Foulere, Simon, of Long Stanton, husbandman 0
4687930 2261791 2261791 defendant Foulere Simon husbandman 723387 723387 Foulere, Simon, of Long Stanton, husbandman 0
4687932 2261791 2261791 defendant Jeffrey John husbandman 723387 723387 Jeffrey, John, of Long Stanton, husbandman 2
4719688 2271505 2271505 defendant Fermour Warrin farmer 723387 723387 Fermour, Warrin, of Long Stanton, farmer 2
4725399 2273237 2273237 defendant Foulere Simon husbandman 723387 723387 Foulere, Simon, of Long Stanton, husbandman 0
4730116 2274620 2274620 defendant Barbour William yeoman 723387 723387 Barbour, William, of Long Stanton, yeoman 0
4756606 2282430 2282430 defendant Yutte or Yntte John yeoman 723387 723387 Yutte or Yntte, John, of Long Stanton, yeoman 0
4762683 2284308 2284308 defendant Cheyne John gent 723387 723387 Cheyne, John, of Long Stanton, gent 0
4815472 2300944 2300944 defendant Cheyne John esq 723387 723387 Cheyne, John, of Long Stanton, esq 0
4826956 2304469 2304469 defendant Haukyn John husbandman 723387 723387 Haukyn, John, of Long Stanton, husbandman 0
4864076 2315739 2315739 defendant Driffeld William yeoman 723387 723387 Driffeld, William, of Long Stanton, yeoman 2
4877674 2319978 2319978 defendant Haukyn John husbandman 723387 723387 Haukyn, John, of Long Stanton, husbandman 0
4877675 2319978 2319978 defendant Driffeld William yeoman 723387 723387 Driffeld, William, of Long Stanton, yeoman 1
4893333 2324621 2324621 defendant Atlowe William husbandman 723387 723387 Atlowe, William, of Long Stanton, husbandman 2
4893334 2324621 2324621 defendant Phipers John husbandman 723387 723387 Phipers, John, of Long Stanton, husbandman 3
4906175 2328522 2328522 defendant Adam James husbandman 723387 723387 Adam, James, of Long Stanton, husbandman 3
4956908 2344023 2344023 defendant Page John   723387 723387 Page, John, of Long Stanton 3
4956909 2344023 2344023 defendant Haukyn John husbandman 723387 723387 Haukyn, John, of Long Stanton, husbandman 4
4992129 2354537 2354537 defendant Page John husbandman 723387 723387 Page, John, of Long Stanton, husbandman 1
4992130 2354537 2354537 defendant Haukyn John husbandman 723387 723387 Haukyn, John, of Long Stanton, husbandman 2
5018235 2362219 2362219 defendant Astell John husbandman 723387 723387 Astell, John, of Long Stanton, husbandman 0
5042392 2369334 2369334 plaintiff Dee William   723387 723387 Dee, William, of Long Stanton 0
5068859 2377185 2377185 defendant Brounne John gent 723387 723387 Brounne, John, of Long Stanton, gent 0
5068860 2377185 2377185 defendant Haukyn John husbandman 723387 723387 Haukyn, John, of Long Stanton, husbandman 1
5072561 2378280 2378280 defendant Haukyn John husbandman 723387 723387 Haukyn, John, of Long Stanton, husbandman 1
5072565 2378281 2378281 defendant Haukyn John husbandman 723387 723387 Haukyn, John, of Long Stanton, husbandman 1
5104058 2387611 2387611 defendant Hawekyn John yeoman 723387 723387 Hawekyn, John, of Long Stanton, yeoman 3
5104064 2387612 2387612 defendant Hawekyn John yeoman 723387 723387 Hawekyn, John, of Long Stanton, yeoman 3
5107860 2388736 2388736 defendant Page William husbandman 723387 723387 Page, William, of Long Stanton, husbandman 2
5107866 2388737 2388737 defendant Page William husbandman 723387 723387 Page, William,of Long Stanton, husbandman 2
5182770 2410710 2410710 defendant Rede John yeoman 723387 723387 Rede, John, of Long Stanton, yeoman 1
5203553 2416792 2416792 defendant Rede John yeoman 723387 723387 Rede, John, of Long Stanton, yeoman 1
5292296 2442748 2442748 defendant Hawkyn John, junior husbandman 723387 723387 Hawkyn, John, junior, of Long Stanton, husbandman 0
5299433 2444809 2444809 defendant Burgoyn Alice widow 723387 723387 Burgoyn, Alice, of Long Stanton, widow 0
5299434 2444809 2444809 defendant Burgoyn Thomas gent 723387 723387 Burgoyn, Thomas, of Long Stanton, gent 1
5299435 2444809 2444809 defendant Hakton John weaver 723387 723387 Hakton, John, of Long Stanton, weaver 2
5299652 2444868 2444868 defendant Fypers William husbandman 723387 723387 Fypers, William, of Long Stanton, husbandman 1
5299664 2444870 2444870 defendant Fypers William husbandman 723387 723387 Fypers, William, of Long Stanton, husbandman 2
5300373 2445070 2445070 defendant Burgoyn Alice widow 723387 723387 Burgoyn, Alice, of Long Stanton, widow 0
5300374 2445070 2445070 defendant Burgoyn Thomas gent 723387 723387 Burgoyn, Thomas, of Long Stanton, gent 1
5300375 2445070 2445070 defendant Dunham John   723387 723387 Dunham, John, of Long Stanton 2
5300376 2445070 2445070 defendant Justeys Thomas laborer 723387 723387 Justeys, Thomas, of Long Stanton, laborer 3
5300377 2445070 2445070 defendant Pell Roger tailor 723387 723387 Pell, Roger, of Long Stanton, tailor 4
5300378 2445070 2445070 defendant Halton John weaver 723387 723387 Halton, John, of Long Stanton, weaver 5
5332291 2454721 2454721 defendant Dounham John husbandman 723387 723387 Dounham, John, of Long Stanton, husbandman 0
5631507 2553864 2553864 plaintiff Smyth Thomas   723387 723387 Smyth, Thomas, of Long Stanton 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);