names

52 rows where place_id = 688118

✎ 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
4074238 2051085 2051085 defendant Carter James tiler 688118 688118 together with Carter, James, of Biggleswade, tiler 1
4074239 2051085 2051085 defendant Carter William laborer 688118 688118 Carter, William, of Biggleswade, laborer 2
4074241 2051085 2051085 defendant Miller John laborer 688118 688118 Miller, John, of Biggleswade, laborer 4
4518883 2206272 2206272 plaintiff Drawe John   688118 688118 Drawe, John, of Biggleswade 0
4518884 2206272 2206272 defendant Deyster Thomas   688118 688118 Deyster, Thomas, of Biggleswade 0
4551052 2216272 2216272 defendant Smyth Simon   688118 688118 Smyth, Simon, of Biggleswade 0
4575005 2223704 2223704 defendant Selby William   688118 688118 Selby, William, of Biggleswade 0
4644573 2244507 2244507 plaintiff Manypeny John, sen (legal representative) 688118 688118 Manypeny, John, sen, of Biggleswade, executors of 0
4694065 2263646 2263646 defendant Glover William husbandman 688118 688118 Glover, William, of Biggleswade, husbandman 0
4694066 2263646 2263646 defendant Hamond John butcher 688118 688118 Hamond, John, of Biggleswade, butcher 1
4694068 2263646 2263646 defendant Gose John husbandman 688118 688118 Gose, John, of Biggleswade, husbandman 3
4694381 2263742 2263742 defendant Hamond John butcher 688118 688118 Hamond, John, of Biggleswade, butcher 0
4702637 2266231 2266231 plaintiff Halsted William gent 688118 688118 Halsted, William, of Biggleswade, gent 0
4711607 2268958 2268958 defendant Glover William   688118 688118 Glover, William, of Biggleswade, glove maker 0
4715541 2270191 2270191 defendant Brewester William husbandman 688118 688118 Brewester, William, of Biggleswade, husbandman 0
4726008 2273423 2273423 plaintiff Goos John   688118 688118 Goos, John, of Biggleswade 0
4760682 2283685 2283685 defendant Barbour William butcher 688118 688118 Barbour, William, of Biggleswade, butcher 0
4761704 2284004 2284004 defendant Barbour William butcher 688118 688118 Barbour, William, of Biggleswade, butcher 0
4761705 2284004 2284004 defendant Orney William   688118 688118 Orney, William, of Biggleswade, shoe maker 1
4761706 2284004 2284004 defendant Webbe John husbandman 688118 688118 Webbe, John, of Biggleswade, husbandman 2
4766553 2285529 2285529 defendant Drawe Joan widow 688118 688118 Drawe, Joan, of Biggleswade, widow 1
4772019 2287223 2287223 defendant Barbour William butcher 688118 688118 Barbour, William, of Biggleswade, butcher 0
4772024 2287225 2287225 defendant Barbour William butcher 688118 688118 together with Barbour, William, of Biggleswade, butcher 1
4774868 2288133 2288133 defendant Spark Richard yeoman 688118 688118 Spark, Richard, of Biggleswade, yeoman 1
4806343 2298195 2298195 defendant Taillour Roger husbandman 688118 688118 Taillour, Roger, of Biggleswade, husbandman 0
4831550 2305901 2305901 defendant Foderby Thomas butcher 688118 688118 Foderby, Thomas, of Biggleswade, butcher 0
4842587 2309217 2309217 defendant Stokkere John husbandman 688118 688118 Stokkere, John, of Biggleswade, husbandman 0
4842588 2309217 2309217 defendant Cooke John yeoman 688118 688118 Cooke, John, of Biggleswade, yeoman 1
4849773 2311399 2311399 plaintiff Stratton Thomas   688118 688118 Stratton, Thomas, of Biggleswade 0
4853228 2312427 2312427 defendant Foderby Thomas butcher 688118 688118 Foderby, Thomas, of Biggleswade, butcher 1
4992500 2354640 2354640 plaintiff Stratton Thomas gent 688118 688118 Stratton, Thomas, of Biggleswade, gent 1
5000858 2357127 2357127 plaintiff Marshall John   688118 688118 Marshall, John, of Biggleswade 0
5000859 2357127 2357127 defendant Petypas George husbandman 688118 688118 Petypas, George, of Biggleswade, husbandman 0
5152522 2401874 2401874 defendant Fuller Thomas fuller 688118 688118 Fuller, Thomas, of Biggleswade, fuller 0
5152523 2401874 2401874 defendant Grymmesby John fuller 688118 688118 Grymmesby, John, of Biggleswade, fuller 1
5163341 2405014 2405014 defendant Pygge John carpenter 688118 688118 Pygge, John, of Biggleswade, carpenter 0
5170257 2407031 2407031 defendant Fuller Thomas fuller 688118 688118 Fuller, Thomas, of Biggleswade, fuller 0
5170258 2407031 2407031 defendant Grymmesby John fuller 688118 688118 Grymmesby, John, of Biggleswade, fuller 1
5173810 2408037 2408037 plaintiff Pope Richard   688118 688118 Pope, Richard, of Biggleswade 0
5177026 2408975 2408975 defendant Pygge John carpenter 688118 688118 Pygge, John, of Biggleswade, carpenter 0
5187773 2412143 2412143 defendant Fuller Thomas fuller 688118 688118 Fuller, Thomas, of Biggleswade, fuller 0
5187774 2412143 2412143 defendant Grymmesby John fuller 688118 688118 Grymmesby, John, of Biggleswade, fuller 1
5193504 2413825 2413825 defendant Langford Thomas husbandman 688118 688118 Langford, Thomas, of Biggleswade, husbandman 4
5201125 2416091 2416091 defendant Beton George husbandman 688118 688118 Beton, George, of Biggleswade, husbandman 0
5205711 2417414 2417414 defendant Fuller Thomas fuller 688118 688118 Fuller, Thomas, of Biggleswade, fuller 0
5205712 2417414 2417414 defendant Grymmesby John fuller 688118 688118 Grymmesby, John, of Biggleswade, fuller 1
5374772 2467703 2467703 defendant Baldwyn Thomas husbandman 688118 688118 Baldwyn, Thomas, of Biggleswade, husbandman 1
5386399 2471180 2471180 defendant Oliver Richard butcher 688118 688118 Oliver, Richard, of Biggleswade, butcher 1
5393143 2473110 2473110 defendant Ussher Simon miller 688118 688118 Ussher, Simon, of Biggleswade, miller 0
5398241 2474566 2474566 defendant Kyng William yeoman 688118 688118 Kyng, William, of Biggleswade, yeoman 2
5475477 2497665 2497665 defendant Graunte John butcher 688118 688118 Graunte, John, of Biggleswade, butcher 0
5609242 2537795 2537795 defendant Gadewyn (illegible) husbandman 688118 688118 Gadewyn, ---, of Biggleswade, husbandman 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);