names

32 rows where place_id = 622868

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3749340 1941717 1941717 defendant Hollok John husbandman 622868 622868 Hollok, John, of Kenardyngton, husbandman 0
3749341 1941717 1941717 defendant Phelyp Thomas husbandman 622868 622868 Phelyp, Thomas, of Kenardyngton, husbandman 1
3749342 1941717 1941717 defendant Phelyp Edward husbandman 622868 622868 Phelyp, Edward, of Kenardyngton, husbandman 2
3749343 1941717 1941717 defendant Parnell Edward husbandman 622868 622868 Parnell, Edward, of Kenardyngton, husbandman 3
3749344 1941717 1941717 defendant Holmes John husbandman 622868 622868 Holmes, John, of Kenardyngton, husbandman 4
3749345 1941717 1941717 defendant Golas Robert husbandman 622868 622868 Golas, Robert, of Kenardyngton, husbandman 5
3749346 1941717 1941717 defendant a Wood Richard husbandman 622868 622868 a Wood, Richard, of Kenardyngton, husbandman 6
3749347 1941717 1941717 defendant Luddyk William husbandman 622868 622868 Luddyk, William, of Kenardyngton, husbandman 7
3749348 1941717 1941717 defendant Doregge Richard husbandman 622868 622868 Doregge, Richard, of Kenardyngton, husbandman 8
3846274 1972393 1972393 defendant Horn Roger esq 622868 622868 Horn, Roger, of Kenardyngton, esq 0
3846275 1972393 1972393 defendant Goller Robert laborer 622868 622868 Goller, Robert, of Kenardyngton, laborer 1
3846276 1972393 1972393 defendant Frencheman Charles laborer 622868 622868 Frencheman, Charles, of Kenardyngton, laborer 2
3846277 1972393 1972393 defendant Brenam John laborer 622868 622868 Brenam, John, of Kenardyngton, laborer 3
3846278 1972393 1972393 defendant Thorp Stephen laborer 622868 622868 Thorp, Stephen, of Kenardyngton, laborer 4
3846279 1972393 1972393 defendant Bland William laborer 622868 622868 Bland, William, of Kenardyngton, laborer 5
3846280 1972393 1972393 defendant Typpyng George laborer 622868 622868 Typpyng, George, of Kenardyngton, laborer 6
3846281 1972393 1972393 defendant Cowper John laborer 622868 622868 Cowper, John, of Kenardyngton, laborer 7
3846282 1972393 1972393 defendant Philipp Peter laborer 622868 622868 Philipp, Peter, of Kenardyngton, laborer 8
3846283 1972393 1972393 defendant Hoope Thomas laborer 622868 622868 Hoope, Thomas, of Kenardyngton, laborer 9
3846284 1972393 1972393 defendant Adam John laborer 622868 622868 Adam, John, of Kenardyngton, laborer 10
3846285 1972393 1972393 defendant Lodewile Thomas laborer 622868 622868 Lodewile, Thomas, of Kenardyngton, laborer 11
3972954 2015113 2015113 defendant Oderton Edward husbandman 622868 622868 (Oderton, Edward, of Kenardyngton, husbandman 4
4146368 2076880 2076880 defendant Kyrstye John laborer 622868 622868 Kyrstye, John, of Kenardyngton, laborer 0
4146370 2076881 2076881 defendant Nutwyck James husbandman 622868 622868 Nutwyck, James, of Kenardyngton, husbandman 0
4493578 2198695 2198695 defendant Lye John   622868 622868 Lye, John, of Kenardyngton 0
5401955 2475617 2475617 plaintiff Horne Henry esq 622868 622868 Horne, Henry, of Kenardyngton, esq 0
5414864 2479376 2479376 plaintiff Horne Henry esq 622868 622868 Horne, Henry, of Kenardyngton, esq 0
5430792 2484148 2484148 plaintiff Horne Henry esq 622868 622868 Horne, Henry, of Kenardyngton, esq 0
5459855 2492877 2492877 plaintiff Horne Henry esq 622868 622868 Horne, Henry, of Kenardyngton, esq 0
5570303 2525880 2525880 defendant Folcok Thomas husbandman 622868 622868 Folcok, Thomas, of Kenardyngton, husbandman 0
5570305 2525881 2525881 defendant Cudword Robert clerk 622868 622868 Cudword, Robert, of Kenardyngton, clerk 0
5571998 2526354 2526354 defendant Folcok Thomas husbandman 622868 622868 Folcok, Thomas, of Kenardyngton, husbandman 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);