names

61 rows where place_id = 759066

✎ 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
4458904 2187833 2187833 defendant Mounpelers Thomas   759066 759066 Mounpelers, Thomas, of Swafham Bulbek 0
4458907 2187834 2187834 defendant Mounpelers Thomas   759066 759066 Mounpelers, Thomas, of Swafham Bulbek 0
4465350 2189838 2189838 defendant Dobat John   759066 759066 Dobat, John, of Swafham Bulbek 0
4491048 2197892 2197892 defendant Trygg Richard   759066 759066 Trygg, Richard, of Swafham Bulbek 0
4586719 2227250 2227250 defendant Pach John   759066 759066 Pach, John, of Swafham Bulbek 2
4588582 2227803 2227803 defendant pacche John   759066 759066 pacche, John, of Swafham Bulbek 0
4631754 2240815 2240815 defendant Trigge Richard   759066 759066 Trigge, Richard, of Swafham Bulbek 0
4632323 2240997 2240997 defendant Elmham John   759066 759066 Elmham, John, of Swafham Bulbek 0
4633440 2241314 2241314 defendant Vyncent John   759066 759066 Vyncent, John, of Swafham Bulbek 1
4633446 2241315 2241315 defendant Vyncent John   759066 759066 Vyncent, John, of Swafham Bulbek 1
4645124 2244644 2244644 plaintiff Momplers Thomas   759066 759066 Momplers, Thomas, of Swafham Bulbek 0
4645125 2244644 2244644 defendant Helmham John, sen   759066 759066 Helmham, John, sen, of Swafham Bulbek 0
4682091 2260019 2260019 defendant Bryd John husbandman 759066 759066 Bryd, John, of Swafham Bulbek, husbandman 0
4682095 2260020 2260020 defendant Euestas Thomas husbandman 759066 759066 Euestas, Thomas, of Swafham Bulbek, husbandman 2
4690051 2262441 2262441 defendant Harlewyn Richard husbandman 759066 759066 Harlewyn, Richard, of Swafham Bulbek, husbandman 0
4698895 2265134 2265134 defendant Vyncent John husbandman 759066 759066 Vyncent, John, of Swafham Bulbek, husbandman 3
4702726 2266252 2266252 defendant Eustas Thomas husbandman 759066 759066 Eustas, Thomas, of Swafham Bulbek, husbandman 0
4702842 2266284 2266284 plaintiff Harlewyn Richard   759066 759066 Harlewyn, Richard, of Swafham Bulbek 0
4702843 2266284 2266284 plaintiff Wrenne Robert   759066 759066 Wrenne, Robert, of Swafham Bulbek 1
4702844 2266284 2266284 defendant Treversham or Trenersham Thomas husbandman 759066 759066 Treversham or Trenersham, Thomas, of Swafham Bulbek, husbandman 0
4719031 2271300 2271300 defendant Vincent John tanner 759066 759066 Vincent, John, of Swafham Bulbek, tanner 1
4725053 2273131 2273131 defendant Goldyng John tailor 759066 759066 Goldyng, John, of Swafham Bulbek, tailor 2
4725054 2273131 2273131 defendant Davy Walter   759066 759066 Davy, Walter, of Swafham Bulbek, shoe maker 3
4725063 2273134 2273134 defendant Goldyng John tailor 759066 759066 Goldyng, John, of Swafham Bulbek, tailor 2
4725064 2273134 2273134 defendant Davy Walter   759066 759066 Davy, Walter, of Swafham Bulbek, shoe maker 3
4726769 2273643 2273643 defendant Eustas Thomas husbandman 759066 759066 Eustas, Thomas, of Swafham Bulbek, husbandman 0
4726775 2273644 2273644 defendant Vyncent John tanner 759066 759066 Vyncent, John, of Swafham Bulbek, tanner 0
4728534 2274163 2274163 defendant Teverysham Thomas husbandman 759066 759066 Teverysham, Thomas, of Swafham Bulbek, husbandman 1
4736130 2276436 2276436 defendant Brunne John miller 759066 759066 Brunne, John, of Swafham Bulbek, miller 0
4738022 2276994 2276994 defendant Brid John husbandman 759066 759066 Brid, John, of Swafham Bulbek, husbandman 0
4743407 2278602 2278602 defendant Pacche John husbandman 759066 759066 Pacche, John, of Swafham Bulbek, husbandman 0
4743410 2278603 2278603 defendant Wodeston Robert husbandman 759066 759066 Wodeston, Robert, of Swafham Bulbek, husbandman 0
4743411 2278603 2278603 defendant Harlewyn Richard husbandman 759066 759066 Harlewyn, Richard, of Swafham Bulbek, husbandman 1
4743412 2278603 2278603 defendant Deye Thomas husbandman 759066 759066 Deye, Thomas, of Swafham Bulbek, husbandman 2
4743413 2278603 2278603 defendant Eustas Thomas husbandman 759066 759066 Eustas, Thomas, of Swafham Bulbek, husbandman 3
4746150 2279365 2279365 defendant Ewestas Thomas husbandman 759066 759066 Ewestas, Thomas, of Swafham Bulbek, husbandman 4
4748253 2279997 2279997 defendant Teverysham Thomas butcher 759066 759066 Teverysham, Thomas, of Swafham Bulbek, butcher 0
4748254 2279997 2279997 defendant Eustas Thomas husbandman 759066 759066 Eustas, Thomas, of Swafham Bulbek, husbandman 1
4748258 2279998 2279998 defendant Teverysham Thomas butcher 759066 759066 Teverysham, Thomas, of Swafham Bulbek, butcher 0
4748259 2279998 2279998 defendant Eustas Thomas husbandman 759066 759066 Eustas, Thomas, of Swafham Bulbek, husbandman 1
4752381 2281155 2281155 defendant Landewade Richard husbandman 759066 759066 Landewade, Richard, of Swafham Bulbek, husbandman 0
4752382 2281155 2281155 defendant Davy Walter shoemaker 759066 759066 Davy, Walter, of Swafham Bulbek, shoemaker 1
4755897 2282228 2282228 defendant Humfrey William husbandman 759066 759066 Humfrey, William, of Swafham Bulbek, husbandman 0
4797563 2295407 2295407 defendant Deye Thomas husbandman 759066 759066 Deye, Thomas, of Swafham Bulbek, husbandman 0
4800589 2296365 2296365 defendant Pacche John, junior husbandman 759066 759066 Pacche, John, junior, of Swafham Bulbek, husbandman 4
4812613 2300061 2300061 defendant Souter William shoemaker 759066 759066 Souter, William, of Swafham Bulbek, shoemaker 1
4832598 2306221 2306221 defendant Dene Thomas husbandman 759066 759066 Dene, Thomas, of Swafham Bulbek, husbandman 0
4832599 2306221 2306221 defendant Gerold John husbandman 759066 759066 Gerold, John, of Swafham Bulbek, husbandman 1
4836998 2307530 2307530 defendant Pacche John, sen husbandman 759066 759066 Pacche, John, sen, of Swafham Bulbek, husbandman 1
4836999 2307530 2307530 defendant Beveriche John husbandman 759066 759066 Beveriche, John, of Swafham Bulbek, husbandman 2
5107729 2388694 2388694 defendant Aldeham John yeoman 759066 759066 Aldeham, John, of Swafham Bulbek, yeoman 0
5107730 2388694 2388694 defendant Hasele Robert husbandman 759066 759066 Hasele, Robert, of Swafham Bulbek, husbandman 1
5107732 2388694 2388694 defendant Pacche Thomas husbandman 759066 759066 Pacche, Thomas, of Swafham Bulbek, husbandman 3
5107737 2388695 2388695 defendant Aldeham John yeoman 759066 759066 Aldeham, John, of Swafham Bulbek, yeoman 0
5107738 2388695 2388695 defendant Hasele Robert husbandman 759066 759066 Hasele, Robert, of Swafham Bulbek, husbandman 1
5107740 2388695 2388695 defendant Pacche Thomas husbandman 759066 759066 Pacche, Thomas, of Swafham Bulbek, husbandman 3
5342678 2457911 2457911 defendant Pacche John husbandman 759066 759066 Pacche, John, of Swafham Bulbek, husbandman 0
5342679 2457911 2457911 defendant Burn Richard miller 759066 759066 Burn, Richard, of Swafham Bulbek, miller 1
5463039 2493857 2493857 defendant Pache John husbandman 759066 759066 Pache, John, of Swafham Bulbek, husbandman 0
5503421 2505978 2505978 defendant Halough William gent 759066 759066 Halough, William, of Swafham Bulbek, gent 0
5517738 2510389 2510389 defendant Halough William gent 759066 759066 Halough, William, of Swafham Bulbek, gent 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);