names

47 rows where place_id = 587380

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591257 1864892 1864892 defendant Rixman John husbandman 587380 587380 Rixman, John, of Sourton, husbandman 0
3599335 1867437 1867437 defendant Wyke Alice widow 587380 587380 Wyke, Alice, of Sourton, widow 0
3599336 1867437 1867437 defendant Carre Robert husbandman 587380 587380 Carre, Robert, of Sourton, husbandman 1
3599337 1867437 1867437 defendant Raddon John, junior   587380 587380 Raddon, John, junior, of Sourton, groom 2
3599338 1867437 1867437 defendant Horwell Thomas laborer 587380 587380 Horwell, Thomas, of Sourton, laborer 3
3599339 1867437 1867437 defendant Hudman William laborer 587380 587380 Hudman, William, of Sourton, laborer 4
3599340 1867437 1867437 defendant Combe Henry laborer 587380 587380 Combe, Henry, of Sourton, laborer 5
3599343 1867437 1867437 defendant Stondon John husbandman 587380 587380 Stondon, John, of Sourton, husbandman 8
3610909 1871086 1871086 defendant Rewe Robert husbandman 587380 587380 Rewe, Robert, of Sourton, husbandman 0
3629243 1904015 1904015 defendant Blacheford Walter husbandman 587380 587380 Blacheford, Walter, of Sourton, husbandman 0
3629277 1904018 1904018 defendant Wrey Walter gent 587380 587380 Wrey, Walter, of Sourton, gent 10
3674147 1917952 1917952 defendant Horwell Thomas husbandman 587380 587380 Horwell, Thomas, of Sourton, husbandman 0
3685670 1921675 1921675 defendant Assherygge Thomas fisher 587380 587380 Assherygge, Thomas, of Sourton, fisher 0
3708928 1929084 1929084 defendant Riche John husbandman 587380 587380 Riche, John, of Sourton, husbandman 0
3708929 1929084 1929084 defendant Langford William husbandman 587380 587380 Langford, William, of Sourton, husbandman 1
3734543 1937049 1937049 defendant Payn Richard butcher 587380 587380 Payn, Richard, of Sourton, butcher 3
3758570 1944678 1944678 defendant Payn Richard husbandman 587380 587380 Payn, Richard, of Sourton, husbandman 0
3758571 1944678 1944678 defendant Ryche John husbandman 587380 587380 Ryche, John, of Sourton, husbandman 1
3758572 1944678 1944678 defendant Crambere John   587380 587380 Crambere, John, of Sourton, groom 2
3758573 1944678 1944678 defendant Blakedon Thomas   587380 587380 Blakedon, Thomas, of Sourton, groom 3
3758575 1944679 1944679 defendant Pyn Richard husbandman 587380 587380 Pyn, Richard, of Sourton, husbandman 0
3758576 1944679 1944679 defendant Ryche John husbandman 587380 587380 Ryche, John, of Sourton,husbandman 1
3758577 1944679 1944679 defendant Crambere John   587380 587380 Crambere, John, of Sourton,groom 2
3758578 1944679 1944679 defendant Blakedon Thomas   587380 587380 Blakedon, Thomas, of Sourton, groom 3
3766145 1947063 1947063 defendant Preter William husbandman 587380 587380 Preter, William, of Sourton, husbandman 1
3766147 1947064 1947064 defendant Preter William husbandman 587380 587380 Preter, William, of Sourton, husbandman 0
3784094 1952807 1952807 defendant Preter William husbandman 587380 587380 Preter, William, of Sourton, husbandman 0
3786722 1953646 1953646 defendant Lyllecrop Robert husbandman 587380 587380 Lyllecrop, Robert, of Sourton, husbandman 0
3794115 1956028 1956028 defendant Payn Richard husbandman 587380 587380 Payn, Richard, of Sourton, husbandman 0
3794116 1956028 1956028 defendant Riche Richard husbandman 587380 587380 Riche, Richard, of Sourton, husbandman 1
3794117 1956028 1956028 defendant Cranbery John   587380 587380 Cranbery, John, of Sourton, groom 2
3794118 1956028 1956028 defendant Blakedon Thomas   587380 587380 Blakedon, Thomas, of Sourton, groom 3
3880153 1983616 1983616 defendant Lyllycropp John husbandman 587380 587380 Lyllycropp, John, of Sourton, husbandman 0
3880154 1983616 1983616 defendant Lyllycropp Thomas husbandman 587380 587380 Lyllycropp, Thomas, of Sourton, husbandman 1
3880155 1983616 1983616 defendant Esworthy Robert husbandman 587380 587380 Esworthy, Robert, of Sourton, husbandman 2
4150666 2078371 2078371 defendant Soper Thomas husbandman 587380 587380 Soper, Thomas, of Sourton, husbandman 2
4919451 2332588 2332588 defendant Frank John chaplain 587380 587380 Frank, John, of Sourton, chaplain 1
4942396 2339608 2339608 defendant Franke John chaplain 587380 587380 Franke, John, of Sourton, chaplain 0
4996193 2355718 2355718 defendant Vela John husbandman 587380 587380 Vela, John, of Sourton, husbandman 0
5004002 2358063 2358063 defendant Lake John, sen husbandman 587380 587380 Lake, John, sen, of Sourton, husbandman 1
5026358 2364598 2364598 defendant Felyp Richard husbandman 587380 587380 Felyp, Richard, of Sourton, husbandman 0
5033688 2366733 2366733 defendant Taverner Thomas   587380 587380 Taverner, Thomas, of Sourton, mason 0
5033689 2366733 2366733 defendant Phelyp Richard husbandman 587380 587380 Phelyp, Richard, of Sourton, husbandman 1
5522485 2511851 2511851 defendant Langeford John yeoman 587380 587380 Langeford, John, of Sourton, yeoman 1
5583598 2529945 2529945 defendant Jurden John husbandman 587380 587380 Jurden, John, of Sourton, husbandman 0
5583599 2529945 2529945 defendant Lillecrop John husbandman 587380 587380 Lillecrop, John, of Sourton, husbandman 1
5583600 2529945 2529945 defendant Ebestworthy Walter husbandman 587380 587380 Ebestworthy, Walter, of Sourton, husbandman 2

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);