names

27 rows where place_id = 602330

✎ 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
3649571 1910255 1910255 defendant Maden Henry husbandman 602330 602330 Maden, Henry, of Whyttyngton, husbandman 0
3649572 1910255 1910255 defendant Shaa James husbandman 602330 602330 Shaa, James, of Whyttyngton, husbandman 1
3671432 1917044 1917044 defendant Maryot John husbandman 602330 602330 Maryot, John, of Whyttyngton, husbandman 1
3671433 1917044 1917044 defendant Maryott Richard husbandman 602330 602330 Maryott, Richard, of Whyttyngton, husbandman 2
3703656 1927424 1927424 defendant Thomson alias Tylson Thomas husbandman 602330 602330 Thomson alias Tylson, Thomas, of Whyttyngton, husbandman 0
3703657 1927424 1927424 defendant Thomson alias Tuson Ralph husbandman 602330 602330 Thomson alias Tuson, Ralph, of Whyttyngton, husbandman 1
3703658 1927424 1927424 defendant Holyer William husbandman 602330 602330 Holyer, William, of Whyttyngton, husbandman 2
3708331 1928901 1928901 defendant (not given) Thomas churchwardens of Brown 602330 602330 Brown, Thomas, of Whyttyngton, husbandman, churchwardens of Whyttyngton, 2
3748491 1941462 1941462 plaintiff Grey Edward   602330 602330 Grey, Edward, of Whyttyngton, knight 0
3809303 1960791 1960791 defendant (not given) William churchwardens of Belle 602330 602330 Belle, William, of Whyttyngton, yeoman, churchwardens of Whyttyngton 1
3809307 1960792 1960792 defendant (not given) William churchwardens of Belle 602330 602330 Belle, William, of Whyttyngton, yeoman, churchwardens of Whyttyngton 1
3919281 1996779 1996779 defendant Lloyde John gent 602330 602330 Lloyde, John, of Whyttyngton, gent 0
3985835 2019697 2019697 defendant Astbury James husbandman 602330 602330 Astbury, James, of Whyttyngton, husbandman 0
4019170 2031593 2031593 plaintiff Warner Henry gent 602330 602330 Warner, Henry, of Whyttyngton, gent 0
4019171 2031593 2031593 defendant Thycknes Robert gent 602330 602330 Thycknes, Robert, of Whyttyngton, gent 0
4019172 2031594 2031594 plaintiff Warner Henry   602330 602330 Warner, Henry, of Whyttyngton, gent, attorney of the bench 0
4030327 2035499 2035499 defendant Branner Thomas yeoman 602330 602330 Branner, Thomas, of Whyttyngton, yeoman 1
4050249 2042517 2042517 plaintiff Warner Henry gent 602330 602330 Warner, Henry, of Whyttyngton, gent 0
4050251 2042518 2042518 plaintiff Warner Henry   602330 602330 Warner, Henry, of Whyttyngton, gent, attorney of the bench 0
4054096 2043850 2043850 defendant Dakyn John husbandman 602330 602330 Dakyn, John, of Whyttyngton, husbandman 2
4136206 2073295 2073295 defendant Fawxe William yeoman 602330 602330 Fawxe, William, of Whyttyngton, yeoman 0
4136207 2073295 2073295 defendant Fawxe Joan widow 602330 602330 Fawxe, Joan, of Whyttyngton, widow 1
4974789 2349429 2349429 defendant Kyng Thomas laborer 602330 602330 Kyng, Thomas, of Whyttyngton, laborer 2
5199093 2415487 2415487 defendant Symondes Richard husbandman 602330 602330 Symondes, Richard, of Whyttyngton, husbandman 0
5582171 2529495 2529495 defendant Orme Richard gent 602330 602330 Orme, Richard, of Whyttyngton, gent 0
5586973 2530952 2530952 defendant Chatterton Robert husbandman 602330 602330 Chatterton, Robert, of Whyttyngton, husbandman 0
5596013 2533664 2533664 plaintiff Ray John   602330 602330 Ray, John, of Whyttyngton 1

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