names

36 rows where place_id = 588345

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594170 1865818 1865818 defendant Thayn John husbandman 588345 588345 Thayn, John, of North Mymmes, Herts, husbandman 3
3647515 1909613 1909613 defendant Frowyk Henry esq 588345 588345 Frowyk, Henry, of North Mymmes, Herts, esq 0
3686501 1921929 1921929 defendant Parker Richard yeoman 588345 588345 Parker, Richard, of North Mymmes, Herts, yeoman 2
3703122 1927250 1927250 defendant Byllyngton Thomas esq 588345 588345 Byllyngton, Thomas, of North Mymmes, Herts, esq 0
3703126 1927251 1927251 defendant Byllyngton Thomas gent 588345 588345 (Byllyngton, Thomas, of North Mymmes, Herts, gent 1
3962087 2011321 2011321 defendant Harton George yeoman 588345 588345 Harton, George, of North Mymmes, Herts, yeoman 0
4182459 2089343 2089343 defendant Conyngesbye Philip gent 588345 588345 Conyngesbye, Philip, of North Mymmes, Herts, gent 1
4329735 2140240 2140240 defendant Aldersey Richard yeoman 588345 588345 Aldersey, Richard, of North Mymmes, Herts, yeoman 2
4340553 2143963 2143963 defendant Boron Paul gent 588345 588345 Boron, Paul, of North Mymmes, Herts, gent 0
4357136 2149721 2149721 defendant Borron Paul gent 588345 588345 Borron, Paul, of North Mymmes, Herts, or of Rolleston, Staffs, gent 0
4390623 2161481 2161481 defendant Brome Paul gent 588345 588345 Brome, Paul, of North Mymmes, Herts, gent 0
4718665 2271177 2271177 defendant Sharp William husbandman 588345 588345 Sharp, William, of North Mymmes, Herts, husbandman 1
4948987 2341670 2341670 plaintiff Mildrop John   588345 588345 Mildrop, John, of North Mymmes, Herts 0
4948989 2341671 2341671 plaintiff Mildrop John   588345 588345 Mildrop, John, of North Mymmes, Herts 0
4974803 2349435 2349435 plaintiff Mildrop John   588345 588345 Mildrop, John, of North Mymmes, Herts 0
4974805 2349436 2349436 plaintiff Mildrop John   588345 588345 Mildrop, John, of North Mymmes, Herts 0
5039049 2368326 2368326 defendant Haywod John   588345 588345 Haywod, John, of North Mymmes, Herts, esq, administrators of 1
5076607 2379507 2379507 defendant Cony Peter husbandman 588345 588345 Cony, Peter, of North Mymmes, Herts, husbandman 0
5076611 2379508 2379508 defendant Cony Peter husbandman 588345 588345 Cony, Peter, of North Mymmes, Herts, husbandman 0
5097682 2385748 2385748 defendant Neweman John husbandman 588345 588345 Neweman, John, of North Mymmes, Herts, husbandman 2
5132527 2396006 2396006 defendant Tavy or Tany Walter husbandman 588345 588345 Tavy or Tany, Walter, of North Mymmes, Herts, husbandman 0
5235971 2426104 2426104 defendant Saundre William husbandman 588345 588345 Saundre, William, of North Mymmes, Herts, husbandman 0
5253916 2431339 2431339 defendant Knolles Robert esq 588345 588345 Knolles, Robert, of North Mymmes, Herts, esq 0
5253918 2431340 2431340 defendant Knolles Robert esq 588345 588345 Knolles, Robert, of North Mymmes, Herts, esq 0
5261883 2433825 2433825 defendant Knolles Robert esq 588345 588345 Knolles, Robert, of North Mymmes, Herts, esq 0
5261898 2433828 2433828 defendant Knolles Robert esq 588345 588345 Knolles, Robert, of North Mymmes, Herts, esq 0
5286765 2441137 2441137 defendant Harryes William husbandman 588345 588345 Harryes, William, of North Mymmes, Herts, husbandman 4
5329030 2453762 2453762 defendant Snowedon Thomas yeoman 588345 588345 Snowedon, Thomas, of North Mymmes, Herts, yeoman 0
5344995 2458595 2458595 defendant Knollys Robert esq 588345 588345 Knollys, Robert, of North Mymmes, Herts, esq 0
5344997 2458596 2458596 defendant Knollys Robert esq 588345 588345 Knollys, Robert, of North Mymmes, Herts, esq 0
5349339 2459924 2459924 defendant Haddon John maltman 588345 588345 Haddon, John, of North Mymmes, Herts, maltman 0
5349341 2459925 2459925 defendant Jaddon John maltman 588345 588345 Jaddon, John, of North Mymmes, Herts, maltman 0
5381193 2469677 2469677 defendant Knolles Robert esq 588345 588345 Knolles, Robert, of North Mymmes, Herts, esq 0
5387880 2471592 2471592 defendant Knolles Robert esq 588345 588345 Knolles, Robert, of North Mymmes, Herts, esq 0
5495585 2503580 2503580 defendant Fycyer alias Devynshyr Richard smith 588345 588345 Fycyer alias Devynshyr, Richard, of North Mymmes, Herts, smith 2
5602683 2535716 2535716 defendant Yong Thomas husbandman 588345 588345 Yong, Thomas, of North Mymmes, Herts, 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);