names

31 rows where place_id = 594463

✎ 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
3616218 1872714 1872714 defendant Founteyn Henry yeoman 594463 594463 Founteyn, Henry, of Kensyngton, Middx, yeoman 1
3641966 1907935 1907935 defendant Marshall Thomas gent 594463 594463 Marshall, Thomas, of Kensyngton, Middx, gent 0
3658395 1912876 1912876 defendant Harrys Robert husbandman 594463 594463 Harrys, Robert, of Kensyngton, Middx, husbandman 0
3691651 1923547 1923547 defendant Culver William husbandman 594463 594463 Culver, William, of Kensyngton, Middx, husbandman 3
3721464 1933022 1933022 defendant Grenfeld John gent 594463 594463 Grenfeld, John, of Kensyngton, Middx, gent 2
3772622 1949130 1949130 defendant Greynfeld John gent 594463 594463 Greynfeld, John, of Kensyngton, Middx, gent 0
3772636 1949134 1949134 defendant Greynfeld John gent 594463 594463 Greynfeld, John, of Kensyngton, Middx, gent 0
3773220 1949333 1949333 defendant Wigmore John innholder 594463 594463 Wigmore, John, of Kensyngton, Middx, innholder 0
3773227 1949335 1949335 defendant Wygmore John innholder 594463 594463 Wygmore, John, of Kensyngton, Middx, innholder 0
3820621 1964334 1964334 defendant Greynfeld John esq 594463 594463 Greynfeld, John, of Kensyngton, Middx, esq 0
3937388 2002842 2002842 defendant Graynfyle John gent 594463 594463 Graynfyle, John, of Kensyngton, Middx, gent 3
3949897 2007041 2007041 plaintiff Ferris William yeoman 594463 594463 Ferris, William, of Kensyngton, Middx, yeoman 0
3956323 2009276 2009276 defendant Graves William yeoman 594463 594463 Graves, William, of Kensyngton, Middx, yeoman 0
4673755 2257415 2257415 defendant Neweman John yeoman 594463 594463 Neweman, John, of Kensyngton, Middx, yeoman 0
4673756 2257415 2257415 defendant Neweman William yeoman 594463 594463 Neweman, William, of Kensyngton, Middx, yeoman 1
4799544 2296036 2296036 defendant Neweman John husbandman 594463 594463 Neweman, John, of Kensyngton, Middx, husbandman 1
4799610 2296059 2296059 defendant Neweman John husbandman 594463 594463 Neweman, John, of Kensyngton, Middx, husbandman 1
4858090 2313901 2313901 defendant Overton William woodbroker 594463 594463 Overton, William, of Kensyngton, Middx, woodbroker 0
4864170 2315770 2315770 defendant Overton William woodbroker 594463 594463 Overton, William, of Kensyngton, Middx, woodbroker 0
4864172 2315771 2315771 defendant Overton William woodbroker 594463 594463 Overton, William, of Kensyngton, Middx, woodbroker 0
4891704 2324147 2324147 defendant Overton William woodmonger 594463 594463 Overton, William, of Kensyngton, Middx, woodmonger 0
4907151 2328799 2328799 defendant Combe James husbandman 594463 594463 Combe, James, of Kensyngton, Middx, husbandman 2
5035351 2367197 2367197 defendant Twyforth Joan widow 594463 594463 Twyforth, Joan, of Kensyngton, Middx, widow 3
5086454 2382434 2382434 defendant Croyse Roger husbandman 594463 594463 Croyse, Roger, of Kensyngton, Middx, husbandman 5
5086471 2382435 2382435 defendant Croyse Roger husbandman 594463 594463 Croyse, Roger, of Kensyngton, Middx, husbandman 5
5261316 2433648 2433648 defendant Crosse John husbandman 594463 594463 Crosse, John, of Kensyngton, Middx, husbandman 1
5343852 2458262 2458262 defendant Crosse John yeoman 594463 594463 Crosse, John, of Kensyngton, Middx, yeoman 0
5544984 2518539 2518539 defendant Drylond Richard gent 594463 594463 Drylond, Richard, of Kensyngton, Middx, gent 0
5547642 2519327 2519327 defendant Francham John   594463 594463 Francham, John, of Kensyngton, Middx, brick maker 2
5547648 2519328 2519328 defendant Frankham John   594463 594463 Frankham, John, of Kensyngton, Middx, brick maker 2
5548452 2519583 2519583 defendant Dryland Richard gent 594463 594463 Dryland, Richard, of Kensyngton, Middx, 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);