names

62 rows where place_id = 597957

✎ 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
3630537 1904381 1904381 defendant Hartrygge Thomas yeoman 597957 597957 Hartrygge, Thomas, of Maydston, yeoman 0
3633887 1905407 1905407 defendant Hertregge Thomas yeoman 597957 597957 Hertregge, Thomas, of Maydston, yeoman 0
3640711 1907539 1907539 defendant Stannford Robert husbandman 597957 597957 Stannford, Robert, of Maydston, husbandman 0
3640712 1907539 1907539 defendant Coyfe Thomas laborer 597957 597957 Coyfe, Thomas, of Maydston, laborer 1
3654773 1911750 1911750 defendant Kynge William tailor 597957 597957 Kynge, William, of Maydston, tailor 0
3672234 1917314 1917314 defendant Vydean Robert husbandman 597957 597957 Vydean, Robert, of Maydston, husbandman 0
3672646 1917444 1917444 defendant Jenyn Edmund tailor 597957 597957 Jenyn, Edmund, of Maydston, tailor 0
3674040 1917922 1917922 plaintiff Fyssher Robert gent 597957 597957 Fyssher, Robert, of Maydston, gent 0
3674865 1918166 1918166 defendant Chaundeler Richard tiler 597957 597957 Chaundeler, Richard, of Maydston, tiler 2
3675269 1918305 1918305 plaintiff Hartregge Thomas tailor 597957 597957 Hartregge, Thomas, of Maydston, tailor 0
3675272 1918305 1918305 defendant Elyott William fuller 597957 597957 Elyott, William, of Maydston, fuller 2
3676459 1918682 1918682 defendant Dawson William saddler 597957 597957 Dawson, William, of Maydston, saddler 0
3698629 1925784 1925784 defendant Miller Thomas yeoman 597957 597957 Miller, Thomas, of Maydston, yeoman 0
3714913 1930960 1930960 defendant Averey Thomas butcher 597957 597957 Averey, Thomas, of Maydston, butcher 0
3748221 1941370 1941370 defendant Crystmas Richard carpenter 597957 597957 Crystmas, Richard, of Maydston, carpenter 5
3750530 1942079 1942079 defendant Myller Thomas   597957 597957 Myller, Thomas, of Maydston, wax chandler 0
3783577 1952621 1952621 defendant Alffey John sherman 597957 597957 Alffey, John, of Maydston, sherman 0
3787261 1953811 1953811 defendant Maneryng Henry clerk 597957 597957 Maneryng, Henry, of Maydston, clerk 0
3787262 1953811 1953811 defendant Croft Thomas tailor 597957 597957 Croft, Thomas, of Maydston, tailor 1
3795315 1956403 1956403 defendant Fyssher John gent 597957 597957 Fyssher, John, of Maydston, gent 0
3815919 1962884 1962884 plaintiff Hely alias Yeely Richard   597957 597957 Hely alias Yeely, Richard, of Maydston 0
3824516 1965538 1965538 defendant Harre John plumber 597957 597957 Harre, John, of Maydston, plumber 0
3834174 1968630 1968630 defendant Baram David chapman 597957 597957 Baram, David, of Maydston, chapman 1
3849447 1973427 1973427 defendant Ippyngbery John yeoman or pewterer 597957 597957 Ippyngbery, John, of Maydston, yeoman or pewterer 0
3861925 1977448 1977448 defendant Bourham David   597957 597957 Bourham, David, of Maydston, millwright 0
3880911 1983887 1983887 defendant Newenton John yeoman 597957 597957 Newenton, John, of Maydston, yeoman 2
3909217 1993377 1993377 defendant Barham David miller 597957 597957 Barham, David, of Maydston, miller 0
3912784 1994606 1994606 defendant Hopper William (legal representative) 597957 597957 Hopper, William, of Maydston, yeoman, administrator of 4
3923082 1998023 1998023 defendant Hartrige Thomas yeoman 597957 597957 Hartrige, Thomas, of Maydston, yeoman 0
3948666 2006595 2006595 plaintiff Dawson William (legal representative) 597957 597957 Dawson, William, of Maydston, administrator of 0
4000791 2025051 2025051 defendant Wynes Henry pewterer 597957 597957 Wynes, Henry, of Maydston, pewterer 1
4000792 2025051 2025051 defendant Jackson John   597957 597957 Jackson, John, of Maydston tiler 2
4000796 2025053 2025053 defendant Parker Edmund tailor 597957 597957 Parker, Edmund, of Maydston, tailor 0
4000797 2025053 2025053 defendant Wynes Henry pewterer 597957 597957 Wynes, Henry, of Maydston, pewterer 1
4000798 2025053 2025053 defendant Jackson John tiler 597957 597957 Jackson, John, of Maydston, tiler 2
4121956 2068152 2068152 defendant Darrell Nicholas cordwainer 597957 597957 Darrell, Nicholas, of Maydston, cordwainer 0
4133552 2072332 2072332 defendant Fraunces Thomas gent 597957 597957 Fraunces, Thomas, of Maydston, gent 0
4136985 2073576 2073576 defendant Collyer John yeoman 597957 597957 Collyer, John, of Maydston, yeoman 0
4145131 2076457 2076457 defendant Lowes Tobias butcher 597957 597957 Lowes, Tobias, of Maydston, butcher 0
4145143 2076462 2076462 defendant Collyer Richard clothworker 597957 597957 Collyer, Richard, of Maydston, clothworker 0
4183231 2089617 2089617 defendant Forde Thomas   597957 597957 Forde, Thomas, of Maydston, woollen draper 0
4191461 2092582 2092582 defendant Collyer John   597957 597957 Collyer, John, of Maydston, sailor 0
4224764 2104131 2104131 defendant Barham Arthur gent 597957 597957 Barham, Arthur, of Maydston, gent 0
4236460 2108326 2108326 defendant Kelsham Francis gent 597957 597957 Kelsham, Francis, of Maydston, gent 0
4285489 2124858 2124858 defendant Fytche William bricklayer 597957 597957 Fytche, William, of Maydston, bricklayer 0
4325040 2138758 2138758 defendant Broade William shoemaker 597957 597957 Broade, William, of Maydston, shoemaker 0
4334030 2141662 2141662 defendant Reve Edward yeoman 597957 597957 Reve, Edward, of Maydston, yeoman 1
4336643 2142542 2142542 defendant Reynold Arthur mercer 597957 597957 Reynold, Arthur, of Maydston, mercer 0
4359266 2150475 2150475 defendant Reynold Arthur mercer 597957 597957 Reynold, Arthur, of Maydston, mercer 0
4371747 2154954 2154954 defendant Raynold Arthur mercer 597957 597957 Raynold, Arthur, of Maydston, mercer 0
4381997 2158664 2158664 defendant Ridgewaye Alexander fletcher 597957 597957 Ridgewaye, Alexander,of Maydston, fletcher 2
4388239 2160695 2160695 defendant Parker Thomas mercer 597957 597957 Parker, Thomas, of Maydston, mercer 0
4388251 2160700 2160700 defendant Parker Thomas mercer 597957 597957 Parker, Thomas, of Maydston, mercer 0
4412247 2168686 2168686 defendant Pynde George gent 597957 597957 Pynde, George, of Maydston, gent 2
4412248 2168686 2168686 defendant Ebbys John tailor 597957 597957 Ebbys, John, of Maydston, tailor 3
5325502 2452709 2452709 defendant Burforde William   597957 597957 Burforde, William, of Maydston, mason 1
5489909 2501869 2501869 plaintiff Barowe John   597957 597957 Barowe, John, of Maydston 0
5521963 2511684 2511684 defendant Morton Thomas goldsmith 597957 597957 Morton, Thomas, of Maydston, goldsmith 1
5527110 2513052 2513052 defendant Sylver John laborer 597957 597957 Sylver, John, of Maydston, laborer 1
5571570 2526241 2526241 defendant Miller Thomas   597957 597957 Miller, Thomas, of Maydston, wax chandler 1
5599342 2534677 2534677 defendant Jacobbe John smith 597957 597957 Jacobbe, John, of Maydston, smith 0
5603768 2536046 2536046 defendant Gore Robert yeoman 597957 597957 Gore, Robert, of Maydston, yeoman 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);