names

58 rows where place_id = 589579

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598048 1867014 1867014 defendant Morle Robert esq 589579 589579 Morle, Robert, of Glynde, esq 0
3630241 1904306 1904306 defendant A Wodde John, senior yeoman 589579 589579 A Wodde, John, senior, of Glynde, yeoman 0
3630242 1904306 1904306 defendant A Wodde John, junior laborer 589579 589579 A Wodde, John, junior, of Glynde, laborer 1
3630243 1904306 1904306 defendant A Wodde Thomas laborer 589579 589579 A Wodde, Thomas, of Glynde, laborer 2
3646036 1909158 1909158 defendant Pers John weaver 589579 589579 Pers, John, of Glynde, weaver 0
3651771 1910909 1910909 defendant Pers John weaver 589579 589579 Pers, John, of Glynde, weaver 0
3658568 1912932 1912932 defendant Stert John yeoman 589579 589579 Stert, John, of Glynde, yeoman 1
3663086 1914364 1914364 defendant Fynall Thomas husbandman 589579 589579 Fynall, Thomas, of Glynde, husbandman 0
3678803 1919438 1919438 defendant Fynall Thomas husbandman 589579 589579 Fynall, Thomas, of Glynde, husbandman 0
3678807 1919439 1919439 defendant Fynall Thomas husbandman 589579 589579 Fynall, Thomas, of Glynde, husbandman 0
3718103 1931951 1931951 defendant Milles Nicholas yeoman 589579 589579 Milles, Nicholas, of Glynde, yeoman 3
3742423 1939501 1939501 defendant Lucas Richard laborer 589579 589579 Lucas, Richard, of Glynde, laborer 0
3758476 1944646 1944646 defendant Musterden Thomas husbandman 589579 589579 Musterden, Thomas, of Glynde, husbandman 1
3764869 1946679 1946679 defendant breton Alexander husbandman 589579 589579 breton, Alexander, of Glynde, husbandman 3
3764875 1946680 1946680 defendant Fynall Thomas husbandman 589579 589579 Fynall, Thomas, of Glynde, husbandman 1
3776502 1950404 1950404 defendant Musterden Thomas husbandman 589579 589579 Musterden, Thomas, of Glynde, husbandman 1
3778317 1950932 1950932 defendant Musterden Thomas husbandman 589579 589579 Musterden, Thomas, of Glynde, husbandman 0
3778318 1950932 1950932 defendant Wakelyn John laborer 589579 589579 Wakelyn, John, of Glynde, laborer 1
3778319 1950932 1950932 defendant Petyte Nicholas laborer 589579 589579 Petyte, Nicholas, of Glynde, laborer 2
3778321 1950933 1950933 defendant Musterden Thomas husbandman 589579 589579 Musterden, Thomas, of Glynde, husbandman 0
3778322 1950933 1950933 defendant Wakelyn John laborer 589579 589579 Wakelyn, John, of Glynde, laborer 1
3778323 1950933 1950933 defendant Petyte Nicholas laborer 589579 589579 Petyte, Nicholas, of Glynde, laborer 2
3778325 1950934 1950934 defendant Musterden Thomas husbandman 589579 589579 Musterden, Thomas, of Glynde, husbandman 0
3778326 1950934 1950934 defendant Wakelyn John laborer 589579 589579 Wakelyn, John, of Glynde, laborer 1
3778327 1950934 1950934 defendant Petyte Nicholas laborer 589579 589579 Petyte, Nicholas, of Glynde, laborer 2
3782869 1952390 1952390 defendant Bredon Alexander husbandman 589579 589579 Bredon, Alexander, of Glynde, husbandman 4
3793500 1955831 1955831 defendant Hareward John husbandman 589579 589579 Hareward, John, of Glynde, husbandman 0
3793502 1955832 1955832 defendant Harward John husbandman 589579 589579 Harward, John, of Glynde, husbandman 0
3949513 2006901 2006901 defendant Awood William yeoman 589579 589579 Awood, William, of Glynde, yeoman 0
4101077 2060698 2060698 defendant Collyn Nicholas yeoman 589579 589579 Collyn, Nicholas, of Glynde, yeoman 3
4186153 2090644 2090644 defendant Chauntler William husbandman 589579 589579 Chauntler, William, of Glynde, husbandman 1
4225589 2104415 2104415 defendant Guye James yeoman 589579 589579 Guye, James, of Glynde, yeoman 0
4424984 2172652 2172652 defendant Brigedenne Robert   589579 589579 Brigedenne, Robert, of Glynde 0
4434738 2175629 2175629 defendant Wrigedenne Robert   589579 589579 Wrigedenne, Robert, of Glynde 0
4490395 2197697 2197697 defendant Bradon John   589579 589579 Bradon, John, of Glynde 0
4667204 2255474 2255474 defendant Bysshop John   589579 589579 Bysshop, John, of Glynde, bailiff 0
4678686 2258939 2258939 defendant Waleys John esq 589579 589579 Waleys, John, of Glynde, esq 0
4680358 2259469 2259469 defendant Bysshop John   589579 589579 Bysshop, John, of Glynde, bailiff 0
4689717 2262346 2262346 defendant Waleys John esq 589579 589579 Waleys, John, of Glynde, esq 0
4702492 2266192 2266192 defendant Bysshop John   589579 589579 Bysshop, John, of Glynde, bailiff 0
4784964 2291310 2291310 defendant Maye Thomas tailor 589579 589579 Maye, Thomas, of Glynde, tailor 0
4793047 2293917 2293917 defendant Kempe Thomas husbandman 589579 589579 Kempe, Thomas, of Glynde, husbandman 0
4801334 2296607 2296607 defendant Kempe Thomas husbandman 589579 589579 Kempe, Thomas, of Glynde, husbandman 0
4801335 2296607 2296607 defendant May Thomas tailor 589579 589579 May, Thomas, of Glynde, tailor 1
4922024 2333299 2333299 defendant atte Wode Alexander husbandman 589579 589579 atte Wode, Alexander, of Glynde, husbandman 0
5100817 2386655 2386655 defendant Amy Richard chapman 589579 589579 Amy, Richard, of Glynde, chapman 4
5245168 2428747 2428747 defendant Fennys Geoffrey tailor 589579 589579 Fennys, Geoffrey, of Glynde, tailor 0
5245169 2428747 2428747 defendant Sherman John laborer 589579 589579 Sherman, John, of Glynde, laborer 1
5260584 2433443 2433443 defendant Fennys William tailor 589579 589579 Fennys, William, of Glynde, tailor 0
5319386 2450889 2450889 defendant Okyngden William yeoman 589579 589579 Okyngden, William, of Glynde, yeoman 2
5356861 2462205 2462205 defendant Morley Joan widow 589579 589579 Morley, Joan, of Glynde, widow 1
5391350 2472606 2472606 defendant Morley William gent 589579 589579 Morley, William, of Glynde, gent 0
5391352 2472606 2472606 defendant West John yeoman 589579 589579 West, John, of Glynde, yeoman 2
5404336 2476317 2476317 defendant Morley William gent 589579 589579 Morley, William, of Glynde, gent 0
5404338 2476317 2476317 defendant West John   589579 589579 West, John, of Glynde 2
5404353 2476320 2476320 defendant Morley William gent 589579 589579 Morley, William, of Glynde, gent 0
5404355 2476320 2476320 defendant West John yeoman 589579 589579 West, John, of Glynde, yeoman 2
5547318 2519226 2519226 defendant Ratclyff William clerk 589579 589579 Ratclyff, William, of Glynde, clerk 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);