names

99 rows where place_id = 602445

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3641116 1907668 1907668 plaintiff Bayly John (legal representative) 602445 602445 Bayly, John, of Weybred, executor of 0
3650142 1910414 1910414 defendant Jacob Nicholas husbandman 602445 602445 Jacob, Nicholas, of Weybred, husbandman 1
3676044 1918542 1918542 defendant Cooke John husbandman 602445 602445 Cooke, John, of Weybred, husbandman 0
3682778 1920715 1920715 defendant Calle John gent 602445 602445 Calle, John, of Weybred, gent 0
3687660 1922309 1922309 defendant Puntyng Robert husbandman 602445 602445 Puntyng, Robert, of Weybred, husbandman 0
3692383 1923792 1923792 defendant Bettys William husbandman 602445 602445 Bettys, William, of Weybred, husbandman 0
3720638 1932741 1932741 defendant Lawter John husbandman 602445 602445 Lawter, John, of Weybred, husbandman 1
3722371 1933257 1933257 plaintiff Mene Thomas   602445 602445 Mene, Thomas, of Weybred 0
3734442 1937016 1937016 defendant Mene William tanner 602445 602445 Mene, William, of Weybred, tanner 1
3738159 1938149 1938149 plaintiff Mene William (legal representative) 602445 602445 Mene, William, of Weybred, draper, executors of 0
3750878 1942195 1942195 defendant Dade Roger tanner 602445 602445 Dade, Roger, of Weybred, tanner 0
3801136 1958275 1958275 defendant Egermount William miller 602445 602445 Egermount, William, of Weybred, miller 0
3820582 1964322 1964322 defendant Everard Hugh yeoman 602445 602445 Everard, Hugh, of Weybred, yeoman 0
3841535 1970933 1970933 defendant Alger Thomas   602445 602445 Alger, Thomas, of Weybred, wheelwright 0
3855267 1975283 1975283 defendant Calle John gent 602445 602445 Calle, John, of Weybred, gent 1
3858157 1976206 1976206 defendant Alger Thomas   602445 602445 Alger, Thomas, of Weybred, wheelwright 2
3861010 1977166 1977166 plaintiff Elgood John   602445 602445 Elgood, John, of Weybred 0
3887162 1985969 1985969 defendant Chyrche Thomas husbandman 602445 602445 Chyrche, Thomas, of Weybred, husbandman 1
3889462 1986706 1986706 defendant Bacon Richard yeoman 602445 602445 Bacon, Richard, of Weybred, yeoman 1
3892492 1987736 1987736 defendant Mene Thomas yeoman 602445 602445 Mene, Thomas, of Weybred, yeoman 1
3892493 1987736 1987736 defendant Elgood John husbandman 602445 602445 Elgood, John, of Weybred, husbandman 2
3892494 1987736 1987736 defendant Everard Hugh yeoman 602445 602445 Everard, Hugh, of Weybred, yeoman 3
3906867 1992586 1992586 defendant Mene Thomas yeoman 602445 602445 Mene, Thomas, of Weybred, yeoman 1
3906868 1992586 1992586 defendant Elgood John yeoman 602445 602445 Elgood, John, of Weybred, yeoman 2
3906869 1992586 1992586 defendant Everard Hugh yeoman 602445 602445 Everard, Hugh, of Weybred, yeoman 3
3932620 2001204 2001204 defendant Staunton Giles husbandman 602445 602445 Staunton, Giles, of Weybred, husbandman 0
3943245 2004761 2004761 plaintiff Algar Thomas   602445 602445 Algar, Thomas, of Weybred 0
3943247 2004762 2004762 plaintiff Algar Thomas   602445 602445 Algar, Thomas, of Weybred 0
3964457 2012171 2012171 defendant Kettyll Robert husbandman 602445 602445 Kettyll, Robert, of Weybred, husbandman, son of John Kettill, of Weybrede, husbandman 0
3964460 2012172 2012172 defendant Kettyll Robert husbandman 602445 602445 Kettyll, Robert, of Weybred, husbandman, son of John Kettill, or Weybred, husbandman 0
3967794 2013366 2013366 defendant Yonges Francis yeoman 602445 602445 Yonges, Francis, of Weybred, yeoman 0
3971879 2014724 2014724 defendant Meane Thomas husbandman 602445 602445 Meane, Thomas, of Weybred, glover, or of Pulham Mary, husbandman 0
3971881 2014725 2014725 defendant Meane Thomas husbandman 602445 602445 Meane, Thomas, of Weybred, glover, or of Pulham Mary, Norf, husbandman 0
3986725 2019992 2019992 defendant Hudde Thomas potter 602445 602445 Hudde, Thomas, of Weybred, potter 1
4028667 2034901 2034901 defendant Meen Thomas glover 602445 602445 Meen, Thomas, of Weybred, glover 1
4033753 2036724 2036724 defendant Algare Nicholas potter 602445 602445 Algare, Nicholas, of Weybred, potter 0
4041252 2039361 2039361 defendant Algare Thomas yeoman 602445 602445 Algare, Thomas, of Weybred, yeoman 0
4096459 2059062 2059062 defendant Gooche John cooper 602445 602445 Gooche, John, of Weybred, cooper 0
4122435 2068332 2068332 defendant Mylles Thomas potter 602445 602445 Mylles, Thomas, of Weybred, yeoman, potter 0
4123974 2068872 2068872 defendant Mylles Thomas yeoman 602445 602445 Mylles, Thomas, of Weybred, yeoman 0
4132244 2071845 2071845 defendant Mylles Thomas yeoman 602445 602445 Mylles, Thomas, of Weybred, yeoman 0
4135884 2073165 2073165 defendant Mill Thomas yeoman 602445 602445 Mill, Thomas, of Weybred, yeoman 0
4135885 2073165 2073165 defendant Myll John   602445 602445 Myll, John, of Weybred, husbandman, his son 1
4136023 2073221 2073221 defendant Duckett William husbandman 602445 602445 Duckett, William, of Weybred, husbandman 0
4136024 2073221 2073221 defendant Botewright John husbandman 602445 602445 Botewright, John, of Weybred, husbandman 1
4146438 2076903 2076903 defendant Godfrey Robert husbandman 602445 602445 Godfrey, Robert, of Weybred, husbandman 0
4166522 2083786 2083786 defendant Mylles Thomas husbandman 602445 602445 Mylles, Thomas, of Weybred, husbandman 0
4172957 2085994 2085994 defendant Meane Thomas miller 602445 602445 Meane, Thomas, of Weybred, miller 0
4197682 2094746 2094746 defendant Algar Nicholas potter 602445 602445 Algar, Nicholas, of Weybred, potter 0
4199566 2095397 2095397 defendant Godfrey Thomas yeoman 602445 602445 Godfrey, Thomas, of Weybred, yeoman 0
4199567 2095397 2095397 defendant Godfrey John husbandman 602445 602445 Godfrey, John, of Weybred, husbandman 1
4202489 2096410 2096410 defendant Burton Guy husbandman 602445 602445 Burton, Guy, of Weybred, husbandman 3
4202497 2096412 2096412 defendant Burton Guy husbandman 602445 602445 Burton, Guy, of Weybred, husbandman 1
4218062 2101814 2101814 defendant Mene Thomas glover 602445 602445 Mene, Thomas, of Weybred, or of Harleston, Norf, glover 1
4226485 2104735 2104735 defendant Gawdye Owen gent 602445 602445 Gawdye, Owen, of Weybred, gent 0
4234872 2107749 2107749 defendant Meene Robert potter 602445 602445 Meene, Robert, of Weybred, yeoman, potter 0
4234873 2107749 2107749 defendant Meene or Meene att Mill Thomas yeoman 602445 602445 Meene or Meene att Mill, Thomas, of Weybred, yeoman 1
4250931 2113290 2113290 defendant Gawdye Owen gent 602445 602445 Gawdye, Owen, of Weybred, gent 0
4282338 2123722 2123722 defendant Meene Thomas yeoman 602445 602445 Meene, Thomas, of Weybred, yeoman 0
4282339 2123722 2123722 defendant Everard Joan widow 602445 602445 Everard, Joan, of Weybred, widow 1
4282340 2123722 2123722 defendant Meene Nicholas yeoman 602445 602445 Meene, Nicholas, of Weybred, yeoman 2
4310068 2133679 2133679 defendant Meane Thomas yeoman 602445 602445 Meane, Thomas, of Weybred, yeoman 0
4327756 2139608 2139608 defendant Meene alias Mill Thomas yeoman 602445 602445 Meene alias Mill, Thomas, of Weybred, yeoman 2
4338456 2143200 2143200 defendant Storer alias Warren Robert yeoman 602445 602445 Storer alias Warren, Robert, of Weybred, yeoman 1
4338457 2143200 2143200 defendant Rice John yeoman 602445 602445 Rice, John, of Weybred, yeoman 2
4339863 2143715 2143715 defendant Algar Thomas yeoman 602445 602445 Algar, Thomas, of Weybred, yeoman 1
4387670 2160512 2160512 defendant Storer alias Warren Robert yeoman 602445 602445 Storer alias Warren, Robert, of Weybred, yeoman 1
4387671 2160512 2160512 defendant Rice John yeoman 602445 602445 Rice, John, of Weybred, yeoman 2
4390033 2161288 2161288 defendant Evered Robert miller 602445 602445 Evered, Robert, of Weybred, miller 2
4390037 2161289 2161289 defendant Evered Robert miller 602445 602445 Evered, Robert, of Weybred, miller 2
4400516 2164765 2164765 defendant Algar Thomas yeoman 602445 602445 Algar, Thomas, of Weybred, yeoman 2
4400517 2164765 2164765 defendant Algar William yeoman 602445 602445 Algar, William, of Weybred, yeoman 3
4407780 2167168 2167168 defendant Gooderam Thomas tanner 602445 602445 Gooderam, Thomas, of Weybred, tanner 0
4929133 2335534 2335534 plaintiff Stapilton Miles esq 602445 602445 Stapilton, Miles, of Weybred, esq 2
4929140 2335535 2335535 plaintiff Stapilton Miles esq 602445 602445 Stapilton, Miles, of Weybred, esq 2
4929146 2335535 2335535 defendant Stapilton Miles esq 602445 602445 Stapilton, Miles, of Weybred, esq 2
4929170 2335543 2335543 plaintiff Stapylton Miles esq 602445 602445 Stapylton, Miles, of Weybred, esq 2
4929177 2335544 2335544 plaintiff Stapylton Miles esq 602445 602445 Stapylton, Miles, of Weybred, esq. Stapylton, Brain, of Ingham, esq 2
4954585 2343330 2343330 defendant Tyler alias Mors John husbandman 602445 602445 Tyler alias Mors, John, of Weybred, husbandman 0
4954613 2343336 2343336 plaintiff Stapilton Miles esq 602445 602445 Stapilton, Miles, of Weybred, esq 2
5055767 2373295 2373295 defendant Mors Richard yeoman 602445 602445 Mors, Richard, of Weybred, yeoman 3
5055770 2373296 2373296 defendant Mors Richard yeoman 602445 602445 Mors, Richard, of Weybred, yeoman 1
5059525 2374420 2374420 defendant Folkred John laborer 602445 602445 Folkred, John, of Weybred, laborer 3
5103364 2387413 2387413 defendant Mors John   602445 602445 Mors, John, of Weybred, tile maker 0
5115416 2390936 2390936 defendant Chaumbyr John yeoman 602445 602445 Chaumbyr, John, of Weybred, yeoman 0
5115417 2390936 2390936 defendant Godfrey William husbandman 602445 602445 Godfrey, William, of Weybred, husbandman 1
5115418 2390936 2390936 defendant Launce William yeoman 602445 602445 Launce, William, of Weybred, yeoman 2
5115419 2390936 2390936 defendant Betys John laborer 602445 602445 Betys, John, of Weybred, laborer 3
5161178 2404370 2404370 defendant Bere William husbandman 602445 602445 Bere, William, of Weybred, husbandman 0
5175647 2408564 2408564 defendant Bere William husbandman 602445 602445 Bere, William, of Weybred, husbandman 0
5197096 2414897 2414897 defendant Bere William husbandman 602445 602445 Bere, William, of Weybred, husbandman 0
5318036 2450481 2450481 defendant Alger Robert   602445 602445 Alger, Robert, of Weybred, wheelwright 0
5349359 2459928 2459928 defendant Jacob William   602445 602445 Jacob, William, of Weybred, wheelwright 4
5503965 2506150 2506150 defendant Dade Thomas yeoman 602445 602445 Dade, Thomas, of Weybred, yeoman 1
5567089 2524955 2524955 plaintiff Dade Roger tanner 602445 602445 Dade, Roger, of Weybred, tanner 0
5582053 2529453 2529453 plaintiff Dade Roger tanner 602445 602445 Dade, Roger, of Weybred, tanner 0
5597160 2534018 2534018 defendant Lawter John yeoman 602445 602445 Lawter, John, of Weybred, yeoman 0
5597161 2534018 2534018 defendant Todde John husbandman 602445 602445 Todde, John, of Weybred, husbandman 1
5597603 2534149 2534149 plaintiff Dade Roger husbandman 602445 602445 Dade, Roger, of Weybred, 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);