names

44 rows where place_id = 606964

✎ 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
3667160 1915663 1915663 defendant Almot Thomas gent 606964 606964 Almot, Thomas,of Cretyng All Saints, gent 0
3683786 1921064 1921064 defendant Almot Thomas gent 606964 606964 Almot, Thomas, of Cretyng All Saints, gent 0
3683872 1921091 1921091 defendant Dryver Richard husbandman 606964 606964 Dryver, Richard, of Cretyng All Saints, husbandman 1
3694169 1924382 1924382 defendant Sparsall John husbandman 606964 606964 Sparsall, John, of Cretyng all Saints, husbandman 0
3733281 1936642 1936642 defendant Bunwall William husbandman 606964 606964 Bunwall, William, of Cretyng All Saints, husbandman 0
3748293 1941394 1941394 defendant Yong Adam husbandman 606964 606964 Yong, Adam, of Cretyng All Saints, husbandman 2
3760615 1945319 1945319 defendant Almott Thomas gent 606964 606964 Almott, Thomas, of Cretyng All Saints, gent 0
3775848 1950197 1950197 defendant Sparsale John pardoner 606964 606964 Sparsale, John, of Cretyng All Saints, pardoner 2
3793429 1955809 1955809 defendant Sparsehall John pardoner 606964 606964 Sparsehall, John, of Cretyng All Saints, pardoner 2
3842449 1971175 1971175 defendant Almotte Thomas gent 606964 606964 Almotte, Thomas, of Cretyng All Saints, gent 0
3862717 1977723 1977723 defendant Baker Edward husbandman 606964 606964 Baker, Edward, of Cretyng All Saints, husbandman 2
3950226 2007165 2007165 defendant Payne William husbandman 606964 606964 Payne, William, of Cretyng All Saints, husbandman 0
4950852 2342237 2342237 defendant Donche Thomas clerk 606964 606964 Donche, Thomas, of Cretyng All Saints, or of Cretyng St Mary, clerk 1
4957966 2344351 2344351 defendant Dunch Thomas husbandman 606964 606964 Dunch, Thomas, of Cretyng All Saints, husbandman 2
5024022 2363936 2363936 defendant Dunch Thomas clerk 606964 606964 Dunch, Thomas, of Cretyng All Saints, clerk 2
5100784 2386652 2386652 defendant Berkwey Richard husbandman 606964 606964 Berkwey, Richard, of Cretyng All Saints, husbandman 5
5106962 2388468 2388468 defendant Baldry Richard husbandman 606964 606964 Baldry, Richard, of Cretyng All Saints, husbandman 1
5106963 2388468 2388468 defendant Berkwey Richard husbandman 606964 606964 Berkwey, Richard, of Cretyng All Saints, husbandman 2
5112143 2389937 2389937 defendant Berkwey Richard husbandman 606964 606964 Berkwey, Richard, of Cretyng All Saints, husbandman 0
5114439 2390621 2390621 defendant Swalowe John clerk 606964 606964 Swalowe, John, of Cretyng All Saints, clerk 0
5114440 2390621 2390621 defendant Somerton Robert yeoman 606964 606964 Somerton, Robert, of Cretyng All Saints, yeoman 1
5114441 2390621 2390621 defendant Strotle John husbandman 606964 606964 Strotle, John, of Cretyng All Saints, husbandman 2
5114442 2390621 2390621 defendant Sprotle John husbandman 606964 606964 Sprotle, John, of Cretyng All Saints, husbandman 3
5124112 2393508 2393508 defendant Baldry Richard husbandman 606964 606964 Baldry, Richard, of Cretyng All Saints, husbandman 1
5124113 2393508 2393508 defendant Berkwey Richard husbandman 606964 606964 Berkwey, Richard, of Cretyng All Saints, husbandman 2
5124687 2393696 2393696 defendant Thorn Thomas   606964 606964 Thorn, Thomas, of Cretyng All Saints 0
5129834 2395212 2395212 defendant (illegible) John husbandman 606964 606964 ---, John, of Cretyng All Saints, husbandman 4
5130014 2395263 2395263 defendant Knotyng John   606964 606964 Knotyng, John, of Cretyng All Saints 1
5149305 2400927 2400927 defendant Knotyng John yeoman 606964 606964 Knotyng, John, of Cretyng All Saints, yeoman 1
5168271 2406434 2406434 defendant Knotyng John yeoman 606964 606964 Knotyng, John, of Cretyng All Saints, yeoman 1
5183936 2411037 2411037 defendant Balery John husbandman 606964 606964 Balery, John, of Cretyng All Saints, husbandman 4
5184130 2411096 2411096 defendant Knotyng John yeoman 606964 606964 Knotyng, John, of Cretyng All Saints, yeoman 1
5201186 2416105 2416105 defendant Berkwey Richard husbandman 606964 606964 Berkwey, Richard, of Cretyng All Saints, husbandman 5
5213785 2419760 2419760 plaintiff Bradwey John yeoman 606964 606964 Bradwey, John, of Cretyng All Saints, yeoman 0
5283311 2440175 2440175 defendant Baldesore John yeoman 606964 606964 Baldesore, John, of Cretyng All Saints, yeoman 0
5294116 2443252 2443252 defendant Dey Thomas husbandman 606964 606964 Dey, Thomas, of Cretyng All Saints, husbandman 2
5294126 2443255 2443255 defendant Dey Thomas husbandman 606964 606964 Dey, Thomas, of Cretyng All Saints, husbandman 1
5555342 2521565 2521565 defendant Swyft Edmund mercer 606964 606964 Swyft, Edmund, of Cretyng All Saints, mercer 0
5558411 2522410 2522410 defendant Swyfte Edmund husbandman 606964 606964 Swyfte, Edmund, of Cretyng All Saints, husbandman 0
5558412 2522410 2522410 defendant Cook William husbandman 606964 606964 Cook, William, of Cretyng All Saints, husbandman 1
5558413 2522410 2522410 defendant Fraunces Richard husbandman 606964 606964 Fraunces, Richard, of Cretyng All Saints, husbandman 2
5558419 2522410 2522410 defendant Stote Thomas husbandman 606964 606964 Stote, Thomas, of Cretyng All Saints, husbandman 8
5560761 2523114 2523114 defendant Swyfte Edmund chapman 606964 606964 Swyfte, Edmund, of Cretyng All Saints, chapman 1
5589248 2531644 2531644 defendant Almot Thomas gent 606964 606964 Almot, Thomas, of Cretyng All Saints, 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);