names

76 rows where place_id = 586191

✎ 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
3588124 1863935 1863935 defendant Leche John clerk 586191 586191 Leche, John, of Chepyng Walden, clerk 0
3596433 1866512 1866512 defendant Myrkyn Thomas miller 586191 586191 Myrkyn, Thomas, of Chepyng Walden, miller 2
3596435 1866512 1866512 defendant Wode John shoemaker 586191 586191 Wode, John, of Chepyng Walden, shoemaker 4
3598901 1867282 1867282 defendant Walhed William glover 586191 586191 Walhed, William, of Chepyng Walden, glover 0
3635613 1905941 1905941 defendant Mathewe John fishmonger 586191 586191 Mathewe, John, of Chepyng Walden, fishmonger 3
3635619 1905942 1905942 defendant Mathewe John fishmonger 586191 586191 Mathewe, John, of Chepyng Walden, fishmonger 3
3693682 1924217 1924217 defendant Carter John tailor 586191 586191 Carter, John, of Chepyng Walden, tailor 0
3693683 1924217 1924217 defendant Bartelot John laborer 586191 586191 Bartelot, John, of Chepyng Walden, laborer 1
3695539 1924830 1924830 defendant Dedyk William draper 586191 586191 Dedyk, William, of Chepyng Walden, draper 0
3714439 1930811 1930811 defendant Adys Richard tailor 586191 586191 Adys, Richard, of Chepyng Walden, tailor 0
3731126 1935961 1935961 defendant Turpyn William joiner 586191 586191 Turpyn, William, of Chepyng Walden, joiner 0
3746761 1940902 1940902 defendant Burman John husbandman 586191 586191 Burman, John, of Chepyng Walden, husbandman 0
3758821 1944746 1944746 defendant Whyte Richard   586191 586191 Whyte, Richard, of Chepyng Walden, wheelwright 3
3772827 1949193 1949193 defendant Baker Thomas laborer 586191 586191 Baker, Thomas, of Chepyng Walden, laborer 0
3790992 1955019 1955019 defendant Nychols John draper 586191 586191 Nychols, John, of Chepyng Walden, draper 2
3791091 1955047 1955047 defendant Hogan Thomas shoemaker 586191 586191 Hogan, Thomas, of Chepyng Walden, shoemaker 0
3807266 1960170 1960170 defendant Nychols John draper 586191 586191 Nychols, John, of Chepyng Walden, draper 2
3807863 1960344 1960344 defendant Nycollys John draper 586191 586191 Nycollys, John, of Chepyng Walden, draper 3
3889966 1986880 1986880 defendant Raymond Anthony grocer 586191 586191 Raymond, Anthony, of Chepyng Walden, grocer 0
4503372 2201626 2201626 plaintiff Pecok John   586191 586191 Pecok, John, of Chepyng Walden 0
4754201 2281692 2281692 defendant Gerlond John sadler 586191 586191 Gerlond, John, of Chepyng Walden, sadler 0
4791042 2293291 2293291 defendant Systede Robert fishmonger 586191 586191 Systede, Robert, of Chepyng Walden, fishmonger 0
4864701 2315928 2315928 defendant Selyne John husbandman 586191 586191 Selyne, John, of Chepyng Walden, husbandman 2
4937420 2338076 2338076 defendant Raymond John dyer 586191 586191 Raymond, John, of Chepyng Walden, dyer 1
4970678 2348168 2348168 defendant Draper John, junior yeoman 586191 586191 Draper, John, junior, of Chepyng Walden, yeoman 0
5049743 2371548 2371548 defendant landesdale William husbandman 586191 586191 landesdale, William, of Chepyng Walden, husbandman 0
5049880 2371591 2371591 defendant Weste Henry husbandman 586191 586191 Weste, Henry, of Chepyng Walden, husbandman 1
5049881 2371591 2371591 defendant Hunt John husbandman 586191 586191 Hunt, John, of Chepyng Walden, husbandman 2
5073859 2378671 2378671 defendant Dounyng Richard woolman 586191 586191 Dounyng, Richard, of Chepyng Walden, woolman 0
5073860 2378671 2378671 defendant George Thomas, junior butcher 586191 586191 George, Thomas, junior, of Chepyng Walden, butcher 1
5078780 2380142 2380142 plaintiff Bryd or Byrd Thomas (legal representative) 586191 586191 Bryd or Byrd, Thomas, of Chepyng Walden, executors of 0
5104353 2387697 2387697 defendant Holme Thomas yeoman 586191 586191 Holme, Thomas, of Chepyng Walden, yeoman 1
5113722 2390407 2390407 defendant Orgor Roger husbandman 586191 586191 Orgor, Roger, of Chepyng Walden, or of Lytylbury, Essex, husbandman 3
5233658 2425430 2425430 defendant Semer John, senior husbandman 586191 586191 Semer, John, senior, of Chepyng Walden, husbandman 0
5243935 2428416 2428416 defendant Meller Thomas tanner 586191 586191 Meller, Thomas, of Chepyng Walden, tanner 1
5243936 2428416 2428416 defendant Balsham Henry spicer 586191 586191 Balsham, Henry, of Chepyng Walden, spicer 2
5260347 2433363 2433363 defendant Syndirford John tailor 586191 586191 Syndirford, John, of Chepyng Walden, tailor 0
5260352 2433364 2433364 defendant Nooke William shoemaker 586191 586191 (Nooke, William, of Chepyng Walden, shoemaker 1
5260353 2433364 2433364 defendant Syndirford John tailor 586191 586191 together with Syndirford, John, of Chepyng Walden, tailor 2
5264430 2434631 2434631 defendant Tayllour John fisher 586191 586191 Tayllour, John, of Chepyng Walden, fisher 0
5285628 2440820 2440820 defendant Rekefeer Richard smith 586191 586191 Rekefeer, Richard, of Chepyng Walden, smith 0
5287211 2441279 2441279 defendant Hannam John yeoman 586191 586191 Hannam, John, of Chepyng Walden, yeoman 0
5312900 2448891 2448891 defendant Tayllour John fisher 586191 586191 Tayllour, John, of Chepyng Walden, fisher 0
5312901 2448891 2448891 defendant George John butcher 586191 586191 George, John, of Chepyng Walden, butcher 1
5312902 2448891 2448891 defendant Garrard William butcher 586191 586191 Garrard, William, of Chepyng Walden, butcher 2
5369909 2466178 2466178 defendant Mathewe John smith 586191 586191 Mathewe, John, of Chepyng Walden, smith 0
5394171 2473393 2473393 defendant Lopham Joan   586191 586191 Lopham, Joan, of Chepyng Walden, widow, formerly wife of John 1
5397523 2474364 2474364 defendant Draper William yeoman 586191 586191 Draper, William, of Chepyng Walden, yeoman 1
5397524 2474364 2474364 defendant Baker William yeoman 586191 586191 Baker, William, of Chepyng Walden, yeoman 2
5410672 2478134 2478134 defendant Draper William yeoman 586191 586191 Draper, William, of Chepyng Walden, yeoman 1
5410673 2478134 2478134 defendant Barker William yeoman 586191 586191 Barker, William, of Chepyng Walden, yeoman 2
5499081 2504664 2504664 defendant Fuller Thomas weaver 586191 586191 Fuller, Thomas, of Chepyng Walden, weaver 0
5514975 2509524 2509524 defendant Chapman Margery widow 586191 586191 Chapman, Margery, of Chepyng Walden, widow 0
5529251 2513661 2513661 defendant Lambert Thomas mercer 586191 586191 Lambert, Thomas, of Chepyng Walden, mercer 0
5534076 2515195 2515195 plaintiff Abry Andrew   586191 586191 Abry, Andrew, of Chepyng Walden 0
5535728 2515685 2515685 defendant Gybson Thomas   586191 586191 Gybson, Thomas, of Chepyng Walden husbandman 1
5535729 2515685 2515685 defendant Danbery Robert butcher 586191 586191 Danbery, Robert, of Chepyng Walden, butcher 2
5540928 2517286 2517286 defendant Bradley John laborer 586191 586191 Bradley, John, of Chepyng Walden, laborer 0
5540930 2517286 2517286 defendant Lomney Richard   586191 586191 Lomney, Richard, of Chepyng Walden, wheelwright 2
5540931 2517286 2517286 defendant George Robert butcher 586191 586191 George, Robert, of Chepyng Walden, butcher 3
5544302 2518329 2518329 defendant Cok Agnes widow 586191 586191 (Cok, Agnes, of Chepyng Walden, widow 1
5544303 2518329 2518329 defendant Pryk Nicholas mercer 586191 586191 Pryk, Nicholas, of Chepyng Walden, mercer 2
5544546 2518404 2518404 defendant Gybson Agnes widow 586191 586191 Gybson, Agnes, of Chepyng Walden, widow 1
5544709 2518455 2518455 defendant Symon Walter carpenter 586191 586191 Symon, Walter, of Chepyng Walden, carpenter 0
5544746 2518469 2518469 plaintiff Sawnder John grocer 586191 586191 Sawnder, John, of Chepyng Walden, grocer 0
5544749 2518470 2518470 plaintiff Sawnder William grocer 586191 586191 Sawnder, William, of Chepyng Walden, grocer 0
5544751 2518470 2518470 defendant Barker William fisher 586191 586191 Barker, William, of Chepyng Walden, fisher 1
5544809 2518487 2518487 defendant Wilson Edward tailor 586191 586191 Wilson, Edward, of Chepyng Walden, tailor 0
5546128 2518858 2518858 defendant George Robert butcher 586191 586191 George, Robert, of Chepyng Walden, butcher 0
5546298 2518913 2518913 defendant Cok Agnes widow 586191 586191 (Cok, Agnes, of Chepyng Walden, widow 1
5546299 2518913 2518913 defendant Pryk Nicholas mercer 586191 586191 Pryk, Nicholas, of Chepyng Walden, mercer 2
5549761 2519962 2519962 defendant Knyght Thomas chapman 586191 586191 Knyght, Thomas, of Chepyng Walden, chapman 0
5564936 2524331 2524331 defendant Knyght Thomas miller 586191 586191 Knyght, Thomas, of Chepyng Walden, miller 1
5588492 2531406 2531406 defendant Knyght Thomas yeoman 586191 586191 Knyght, Thomas, of Chepyng Walden, yeoman 0
5588493 2531406 2531406 defendant Turnour alias Thurston William yeoman 586191 586191 Turnour alias Thurston, William, of Chepyng Walden, yeoman 1
5603066 2535843 2535843 defendant Turnour John   586191 586191 Turnour, John, of Chepyng Walden 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);