names

57 rows where place_id = 602212

✎ 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
3648991 1910074 1910074 defendant Atkyn John husbandman 602212 602212 Atkyn, John, of Shoreham, husbandman 1
3648992 1910074 1910074 defendant Hybyn John husbandman 602212 602212 Hybyn, John, of Shoreham, husbandman 2
3648999 1910075 1910075 defendant Atkyn John husbandman 602212 602212 Atkyn, John, of Shoreham, husbandman 3
3649000 1910075 1910075 defendant Hylyn John husbandman 602212 602212 Hylyn, John, of Shoreham, husbandman 4
3651591 1910853 1910853 defendant Kyng William laborer 602212 602212 Kyng, William, of Shoreham, laborer 0
3678712 1919408 1919408 plaintiff Alen John clothmaker 602212 602212 Alen, John, of Shoreham, clothmaker 1
3679640 1919700 1919700 defendant Summer Thomas husbandman 602212 602212 Summer, Thomas, of Shoreham, husbandman 0
3679641 1919700 1919700 defendant Grenetre Thomas laborer 602212 602212 Grenetre, Thomas, of Shoreham, laborer 1
3679642 1919700 1919700 defendant Plumley William husbandman 602212 602212 Plumley, William, of Shoreham, husbandman 2
3682332 1920574 1920574 defendant Browne Alan yeoman 602212 602212 Browne, Alan, of Shoreham, yeoman 0
3722093 1933172 1933172 defendant Polhell Thomas yeoman 602212 602212 Polhell, Thomas, of Shoreham, yeoman 0
3722207 1933205 1933205 defendant Atkyn John husbandman 602212 602212 Atkyn, John, of Shoreham, husbandman 0
3722208 1933205 1933205 defendant Blakeman John husbandman 602212 602212 Blakeman, John, of Shoreham, husbandman 1
3729219 1935389 1935389 defendant Aynesworth Roger laborer 602212 602212 Aynesworth, Roger, of Shoreham, laborer 0
3729220 1935389 1935389 defendant Pygeon Miles laborer 602212 602212 Pygeon, Miles, of Shoreham, laborer 1
3744262 1940103 1940103 defendant Rygby Nicholas carpenter 602212 602212 Rygby, Nicholas, of Shoreham, carpenter 0
3744263 1940103 1940103 defendant Rygby Robert carpenter 602212 602212 Rygby, Robert, of Shoreham, carpenter 1
3790623 1954890 1954890 defendant Porter Richard   602212 602212 Porter, Richard, of Shoreham, ploughwright 0
3790624 1954890 1954890 defendant Porter Edmund laborer 602212 602212 Porter, Edmund, of Shoreham, laborer 1
3850389 1973711 1973711 defendant Blakman William husbandman 602212 602212 Blakman, William, of Shoreham, husbandman 1
3988918 2020780 2020780 defendant Gravesend Richard yeoman 602212 602212 Gravesend, Richard, of Shoreham, yeoman 0
3988920 2020781 2020781 defendant Gravesend Richard yeoman 602212 602212 Gravesend, Richard, of Shoreham, yeoman 0
3988922 2020781 2020781 defendant Awood James husbandman 602212 602212 ( Awood, James, of Shoreham, husbandman 2
4003277 2025929 2025929 defendant Whetley Richard laborer 602212 602212 Whetley, Richard, of Shoreham, laborer 1
4063546 2047250 2047250 defendant Earle Richard gent 602212 602212 Earle, Richard, of Shoreham, gent 0
4063909 2047374 2047374 defendant Holmer William yeoman 602212 602212 Holmer, William, of Shoreham, yeoman 0
4063910 2047374 2047374 defendant Fletcher Eleanor widow 602212 602212 Fletcher, Eleanor, of Shoreham, widow 1
4073501 2050807 2050807 defendant Gravesend John yeoman 602212 602212 Gravesend, John, of Shoreham, yeoman 1
4078541 2052623 2052623 defendant Wood Richard merchant 602212 602212 Wood, Richard, of Shoreham, merchant 0
4079556 2052986 2052986 defendant Wood Richard yeoman 602212 602212 Wood, Richard, of Shoreham, yeoman 0
4107014 2062804 2062804 defendant Gravesend Richard yeoman 602212 602212 Gravesend, Richard, of Shoreham, yeoman 0
4107016 2062805 2062805 defendant Gravesend Richard yeoman 602212 602212 Gravesend, Richard, of Shoreham, yeoman 0
4111648 2064415 2064415 defendant Michell John yeoman 602212 602212 Michell, John, of Shoreham, yeoman 3
4129028 2070683 2070683 defendant Goodale Richard husbandman 602212 602212 Goodale, Richard, of Shoreham, husbandman 2
4162914 2082558 2082558 defendant Hester John brewer 602212 602212 Hester, John, of Shoreham, or of Brithelmeston, brewer 0
4179253 2088222 2088222 defendant Olyver John merchant 602212 602212 Olyver, John, of Shoreham, merchant 0
4226876 2104872 2104872 defendant Danyell Thomas husbandman 602212 602212 Danyell, Thomas, of Shoreham, husbandman 0
4230245 2106067 2106067 defendant Browne Robert yeoman 602212 602212 Browne, Robert, of Shoreham, yeoman 0
4235713 2108058 2108058 defendant Homewood Henry yeoman 602212 602212 Homewood, Henry, of Shoreham, yeoman 0
4244131 2111020 2111020 defendant Cowper or Cooper Balhazar yeoman 602212 602212 Cowper or Cooper, Balhazar, of Shoreham, yeoman 0
4368514 2153784 2153784 defendant Stretor John yeoman 602212 602212 Stretor, John, of Shoreham, yeoman 0
4394286 2162687 2162687 defendant Whatman John yeoman 602212 602212 Whatman, John, of Shoreham, yeoman 1
4402428 2165401 2165401 defendant Danyell Thomas laborer 602212 602212 Danyell, Thomas, of Shoreham, laborer 0
4694772 2263858 2263858 defendant Gervays Richard laborer 602212 602212 Gervays, Richard, of Shoreham, laborer 1
4694773 2263858 2263858 defendant Gervays William laborer 602212 602212 Gervays, William, of Shoreham, laborer 2
4758606 2283072 2283072 defendant Tymberden Robert husbandman 602212 602212 Tymberden, Robert, of Shoreham, husbandman 0
4758607 2283072 2283072 defendant Tymberden Thomas husbandman 602212 602212 Tymberden, Thomas, of Shoreham, husbandman 1
4961628 2345442 2345442 defendant Colgate Robert husbandman 602212 602212 Colgate, Robert, of Shoreham, husbandman 1
5087737 2382799 2382799 defendant Benfyld John (legal representative) 602212 602212 Benfyld, John, of Shoreham, esq, executrix of 0
5174519 2408248 2408248 defendant Sepham John gent 602212 602212 Sepham, John, of Shoreham, gent 0
5225149 2423028 2423028 defendant Reve John cordwainer 602212 602212 Reve, John, of Shoreham, cordwainer 0
5225152 2423028 2423028 defendant Blakeman Thomas carpenter 602212 602212 Blakeman, Thomas, of Shoreham, carpenter 3
5488588 2501470 2501470 defendant Browene William yeoman 602212 602212 Browene, William, of Shoreham, yeoman 0
5513128 2508960 2508960 defendant Ketyll John carpenter 602212 602212 Ketyll, John, of Shoreham, carpenter 3
5538677 2516578 2516578 defendant Reve William husbandman 602212 602212 Reve, William, of Shoreham, husbandman 2
5584833 2530334 2530334 defendant Camp Richard, junior upholsterer 602212 602212 Camp, Richard, junior, of Shoreham, yeoman or of London, upholsterer 0
5603414 2535957 2535957 defendant Polhell John yeoman 602212 602212 Polhell, John, of Shoreham, yeoman 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);