names

27 rows where place_id = 602514

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3650473 1910514 1910514 defendant Bradford Christopher gent 602514 602514 Bradford, Christopher, of Daryngton, gent 0
3664968 1914987 1914987 defendant Hardwik John husbandman 602514 602514 Hardwik, John, of Daryngton, husbandman 0
3664969 1914987 1914987 defendant Hill John husbandman 602514 602514 Hill, John, of Daryngton, husbandman 1
3664970 1914987 1914987 defendant Saunder John laborer 602514 602514 Saunder, John, of Daryngton, laborer 2
3664971 1914987 1914987 defendant Bekwith John laborer 602514 602514 Bekwith, John, of Daryngton, laborer 3
3664972 1914987 1914987 defendant Heptonstall Robert husbandman 602514 602514 Heptonstall, Robert, of Daryngton, husbandman 4
3672143 1917285 1917285 defendant Hardwyk Robert husbandman 602514 602514 Hardwyk, Robert, of Daryngton, husbandman 0
3672144 1917285 1917285 defendant Jakson William husbandman 602514 602514 Jakson, William, of Daryngton, husbandman 1
3672145 1917285 1917285 defendant Jakson Agnes widow 602514 602514 Jakson, Agnes, of Daryngton, widow 2
3672146 1917285 1917285 defendant Bekwyth John laborer 602514 602514 Bekwyth, John, of Daryngton, laborer 3
3672148 1917286 1917286 defendant Hardwyk Robert husbandman 602514 602514 Hardwyk, Robert, of Daryngton, husbandman 0
3672149 1917286 1917286 defendant Jakson William husbandman 602514 602514 Jakson, William, of Daryngton, husbandman 1
3672150 1917286 1917286 defendant Jakson Agnes widow 602514 602514 Jakson, Agnes, of Daryngton, widow 2
3672151 1917286 1917286 defendant Bekwyth John laborer 602514 602514 Bekwyth, John, of Daryngton, laborer 3
3798089 1957299 1957299 defendant Bradford Christopher gent 602514 602514 Bradford, Christopher, of Daryngton, gent 0
3965720 2012626 2012626 defendant Johnson William yeoman or saddler 602514 602514 Johnson, William, of Daryngton, or of Steventon Morley, Norf, yeoman or saddler 0
4821605 2302840 2302840 defendant Waryn John husbandman 602514 602514 Waryn, John, of Daryngton, husbandman 0
4821606 2302840 2302840 defendant Wade Robert husbandman 602514 602514 with Wade, Robert, of Daryngton, husbandman 1
4821607 2302840 2302840 defendant Wade John laborer 602514 602514 Wade, John, of Daryngton, laborer 2
4851948 2312043 2312043 defendant Wade Robert husbandman 602514 602514 Wade, Robert, of Daryngton, husbandman 0
4885669 2322391 2322391 defendant Saunder Henry walker 602514 602514 Saunder, Henry, of Daryngton, walker 0
5021344 2363148 2363148 defendant Pagette William yeoman 602514 602514 Pagette, William, of Daryngton, yeoman 0
5464239 2494210 2494210 defendant Rothewell Thomas husbandman 602514 602514 Rothewell, Thomas, of Daryngton, husbandman 0
5464242 2494210 2494210 defendant Barkar Thomas husbandman 602514 602514 Barkar, Thomas, of Daryngton, husbandman 3
5464243 2494210 2494210 defendant Wylkynson John tailor 602514 602514 Wylkynson, John, of Daryngton, tailor 4
5464244 2494210 2494210 defendant Heyford William laborer 602514 602514 Heyford, William, of Daryngton, laborer 5
5495551 2503570 2503570 defendant Taillour Thomas yeoman 602514 602514 Taillour, Thomas, of Daryngton, yeoman 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);