names

21 rows where place_id = 609330

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3677986 1919159 1919159 defendant Stubbes alias Lokwode William yeoman 609330 609330 Stubbes alias Lokwode, William, of Snyterton, yeoman 1
3846520 1972469 1972469 defendant Graty Thomas miller 609330 609330 Graty, Thomas, of Snyterton, miller 1
4053874 2043763 2043763 defendant Daubney Robert husbandman 609330 609330 Daubney, Robert, of Snyterton, husbandman 0
4081027 2053526 2053526 defendant Clarke John husbandman 609330 609330 Clarke, John, of Snyterton, husbandman 0
4405127 2166290 2166290 defendant Townsend William laborer 609330 609330 Townsend, William, of Snyterton, laborer 0
4429213 2173944 2173944 defendant Bokenham John de   609330 609330 Bokenham, John de, of Snyterton, parson of All Saints church 0
4439351 2181576 2181576 defendant Bouse Richard   609330 609330 Bouse, Richard, of Snyterton 0
4582577 2225992 2225992 defendant Leche John   609330 609330 Leche, John, of snyterton 1
4608028 2233629 2233629 plaintiff Bosevyle Thomas   609330 609330 Bosevyle, Thomas, of Snyterton, parson of All Saints church 2
4671525 2256740 2256740 defendant Doraunt Hugh husbandman 609330 609330 Doraunt, Hugh, of Snyterton, husbandman 1
4671526 2256740 2256740 defendant Foster John husbandman 609330 609330 Foster, John, of Snyterton, husbandman 2
4735112 2276131 2276131 defendant Hobbes Thomas husbandman 609330 609330 Hobbes, Thomas, of Snyterton, husbandman 0
4816714 2301324 2301324 defendant Galle Thomas clerk 609330 609330 Galle, Thomas, of Snyterton, clerk 2
4958264 2344440 2344440 defendant Bouse or Bonse Thomas laborer 609330 609330 Bouse or Bonse, Thomas, of Snyterton, laborer 2
4961468 2345392 2345392 defendant Dorant Hugh husbandman 609330 609330 Dorant, Hugh, of Snyterton, husbandman 0
4998280 2356355 2356355 defendant Bokenham Edmund esq 609330 609330 Bokenham, Edmund, of Snyterton, esq 0
5231500 2424798 2424798 defendant Wylly Thomas miller 609330 609330 Wylly, Thomas, of Snyterton, miller 0
5231501 2424798 2424798 defendant Serle Thomas miller 609330 609330 Serle, Thomas, of Snyterton, miller 1
5233279 2425321 2425321 defendant Lyncoln John husbandman 609330 609330 Lyncoln, John, of Snyterton, husbandman 3
5268896 2436018 2436018 defendant Sacheverell Ralph esq 609330 609330 Sacheverell, Ralph, of Snyterton, esq 0
5626558 2552277 2552277 defendant Galle William husbandman 609330 609330 Galle, William, of Snyterton, husbandman 3

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