names

36 rows where place_id = 608098

✎ 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
3672187 1917301 1917301 defendant Atkynson Thomas yeoman 608098 608098 Atkynson, Thomas, of Lounde, yeoman 0
3712744 1930301 1930301 defendant Thawaytes William esq 608098 608098 Thawaytes, William, of Lounde, esq 0
3743461 1939828 1939828 defendant Thwaytys William esq 608098 608098 Thwaytys, William, of Lounde, esq 0
3745133 1940384 1940384 defendant Nabbys Gregory husbandman 608098 608098 Nabbys, Gregory, of Lounde, husbandman 1
3750589 1942103 1942103 defendant Madersey John husbandman 608098 608098 Madersey, John, of Lounde, husbandman 0
3832553 1968101 1968101 defendant Man John husbandman 608098 608098 Man, John, of Lounde, husbandman 2
3844542 1971833 1971833 defendant Shrymplyng Edward husbandman 608098 608098 Shrymplyng, Edward, of Lounde, husbandman 0
3966566 2012940 2012940 defendant Borse John husbandman 608098 608098 Borse, John, of Lounde, husbandman 0
4018401 2031314 2031314 defendant Rysynge John husbandman 608098 608098 Rysynge, John, of Lounde, husbandman 0
4556700 2218030 2218030 defendant Jonessone Robert   608098 608098 Jonessone, Robert, of Lounde 0
4583479 2226256 2226256 plaintiff Frende John   608098 608098 Frende, John, of Lounde 0
4644351 2244440 2244440 plaintiff Luteldale Robert   608098 608098 Luteldale, Robert, of Lounde 0
4686926 2261517 2261517 defendant Wyot Thomas husbandman 608098 608098 Wyot, Thomas, of Lounde, husbandman 0
4786022 2291667 2291667 defendant Alanson John husbandman 608098 608098 Alanson, John, of Lounde, husbandman 6
4820572 2302506 2302506 plaintiff Redborn John   608098 608098 Redborn, John, of Lounde, vicar 0
4820573 2302506 2302506 defendant Waren John de husbandman 608098 608098 Waren, John de, of Lounde, husbandman 0
4993599 2354960 2354960 defendant Warde Henry gent 608098 608098 Warde, Henry, of Lounde, gent 2
5007658 2359139 2359139 defendant chapman William   608098 608098 chapman, William, of Lounde 1
5034270 2366879 2366879 defendant Chapman William yeoman 608098 608098 Chapman, William, of Lounde, yeoman 1
5135359 2396846 2396846 defendant Kirkeby John husbandman 608098 608098 Kirkeby John, of Lounde, husbandman 1
5139808 2398119 2398119 defendant Dodworth William   608098 608098 Dodworth, William, of Lounde 0
5139809 2398119 2398119 defendant Cole Thomas husbandman 608098 608098 Cole, Thomas, of Lounde, husbandman 1
5160774 2404247 2404247 defendant Cole Thomas husbandman 608098 608098 Cole, Thomas, of Lounde, husbandman 1
5175439 2408509 2408509 defendant Cole Thomas husbandman 608098 608098 Cole, Thomas, of Lounde, husbandman 1
5175459 2408512 2408512 defendant Cole Thomas husbandman 608098 608098 Cole, Thomas, of Lounde, husbandman 1
5222148 2422182 2422182 defendant Gee William husbandman 608098 608098 Gee, William, of Lounde, husbandman 0
5248782 2429762 2429762 defendant Ferborough William bucther 608098 608098 Ferborough, William, of Lounde, bucther 8
5265544 2434984 2434984 defendant Draper John butcher 608098 608098 Draper, John, of Lounde, butcher 7
5265558 2434986 2434986 defendant Forborowe Thomas butcher 608098 608098 Forborowe, Thomas, of Lounde, butcher 7
5265559 2434986 2434986 defendant Draper John butcher 608098 608098 Draper, John, of Lounde, butcher 8
5266423 2435245 2435245 defendant Matersey John husbandman 608098 608098 Matersey, John, of Lounde, husbandman 1
5522210 2511764 2511764 defendant Upton Richard husbandman 608098 608098 Upton, Richard, of Lounde, husbandman 1
5540732 2517233 2517233 defendant Gunton Edmund husbandman 608098 608098 Gunton, Edmund, of Lounde, husbandman 1
5540733 2517233 2517233 defendant Candeler Edmund husbandman 608098 608098 Candeler, Edmund, of Lounde, husbandman 2
5625897 2552049 2552049 defendant Esyngton Thomas laborer 608098 608098 Esyngton, Thomas, of Lounde, laborer 0
5630920 2553683 2553683 defendant Alanson John husbandman 608098 608098 Alanson, John, of Lounde, husbandman 4

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