names

71 rows where place_id = 586300

✎ 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
3588383 1864017 1864017 defendant Andrewe Thomas husbandman 586300 586300 Andrewe, Thomas, of Wykhambroke, husbandman 1
3588385 1864017 1864017 defendant Toppysfeld John butcher 586300 586300 Toppysfeld, John, of Wykhambroke, butcher 3
3588386 1864017 1864017 defendant Denham John butcher 586300 586300 Denham, John, of Wykhambroke, butcher 4
3590363 1864626 1864626 defendant Kyng Robert barker 586300 586300 Kyng, Robert, of Wykhambroke, barker 1
3590366 1864626 1864626 defendant Denham John husbandman 586300 586300 Denham, John, of Wykhambroke, husbandman 4
3636875 1906325 1906325 defendant Coteras John butcher 586300 586300 Coteras, John, of Wykhambroke, butcher 2
3648348 1909883 1909883 defendant Kyng John barker 586300 586300 Kyng, John, of Wykhambroke, barker 0
3657615 1912643 1912643 defendant Cease Ralph laborer 586300 586300 Cease, Ralph, of Wykhambroke, laborer 7
3657624 1912644 1912644 defendant Caase Ralph laborer 586300 586300 Caase, Ralph, of Wykhambroke, laborer 7
3710359 1929559 1929559 defendant Mott Robert husbandman 586300 586300 Mott, Robert, of Wykhambroke, husbandman 1
3710757 1929684 1929684 defendant Cote Richard smith 586300 586300 Cote, Richard, of Wykhambroke, smith 4
3710763 1929685 1929685 defendant Cote Richard smith 586300 586300 Cote, Richard, of Wykhambroke, smith 4
3760042 1945136 1945136 defendant Skrevyn Thomas husbandman 586300 586300 Skrevyn, Thomas, of Wykhambroke, husbandman 3
3775446 1950065 1950065 defendant Anderson John smith 586300 586300 Anderson, John, of Wykhambroke, smith 0
3775447 1950065 1950065 defendant Coke Richard smith 586300 586300 Coke, Richard, of Wykhambroke, smith 1
3795163 1956353 1956353 defendant Smyth John yeoman 586300 586300 Smyth, John, of Wykhambroke, yeoman 0
3815466 1962752 1962752 defendant Lotte John smith 586300 586300 Lotte, John, of Wykhambroke, smith 2
3822033 1964786 1964786 defendant Blayse Lambert clerk 586300 586300 Blayse, Lambert, of Wykhambroke, clerk 0
3824018 1965389 1965389 defendant Batman John husbandman 586300 586300 Batman, John, of Wykhambroke, husbandman 1
3826122 1966012 1966012 plaintiff Andrewe Richard husbandman 586300 586300 Andrewe, Richard, of Wykhambroke, husbandman 0
3826124 1966012 1966012 defendant Genne William husbandman 586300 586300 Genne, William, of Wykhambroke, husbandman 1
3826126 1966012 1966012 defendant Whittoppe John husbandman 586300 586300 Whittoppe, John, of Wykhambroke, husbandman 3
3826127 1966012 1966012 defendant Hunt Edward laborer 586300 586300 Hunt, Edward, of Wykhambroke, laborer 4
3831677 1967805 1967805 defendant Lotte John smith 586300 586300 Lotte, John, of Wykhambroke, smith 1
3836237 1969246 1969246 defendant Werliche Agnes   586300 586300 Werliche, Agnes, of Wykhambroke, widow, alias Fletcher, Agnes 0
3846421 1972435 1972435 defendant Kyng Thomas smith 586300 586300 Kyng, Thomas, of Wykhambroke, smith 0
3847133 1972656 1972656 defendant Kyng Thomas smith 586300 586300 Kyng, Thomas, of Wykhambroke, smith 1
3852264 1974307 1974307 defendant Eyer John butcher 586300 586300 Eyer, John, of Wykhambroke, butcher 1
3854866 1975167 1975167 plaintiff Turnour Richard   586300 586300 Turnour, Richard, of Wykhambroke 0
3858222 1976228 1976228 defendant Kyng Thomas smith 586300 586300 Kyng, Thomas, of Wykhambroke, smith 0
3859755 1976762 1976762 defendant Worlyche John gent 586300 586300 (Worlyche, John, of Wykhambroke, gent 1
3862446 1977634 1977634 defendant Kyng Thomas smith 586300 586300 Kyng, Thomas, of Wykhambroke, smith 2
3862655 1977703 1977703 defendant Rogers John husbandman 586300 586300 Rogers, John, of Wykhambroke, husbandman 3
3866743 1979113 1979113 defendant Lotte John husbandman 586300 586300 Lotte, John, of Wykhambroke, husbandman 0
3870333 1980329 1980329 plaintiff Wurlyche alias Fletcher John yeoman 586300 586300 Wurlyche alias Fletcher, John, of Wykhambroke, yeoman 0
3870336 1980329 1980329 defendant Goodchylde alias Hartte John singleman 586300 586300 Goodchylde alias Hartte, John, of Wykhambroke, singleman 2
3870344 1980331 1980331 defendant Kynge Thomas smith 586300 586300 Kynge, Thomas, of Wykhambroke, smith 1
3870345 1980331 1980331 defendant Shawe Gilbert husbandman 586300 586300 Shawe, Gilbert, of Wykhambroke, husbandman 2
3870347 1980331 1980331 defendant Anderson John husbandman 586300 586300 Anderson, John, of Wykhambroke, husbandman 4
3870348 1980331 1980331 defendant Lylly William   586300 586300 Lylly, William, of Wykhambroke 5
3876735 1982461 1982461 defendant Paske John tanner 586300 586300 Paske, John, of Wykhambroke, tanner 0
3876736 1982461 1982461 defendant Lotte John smith 586300 586300 Lotte, John, of Wykhambroke, smith 1
3894065 1988232 1988232 defendant Lote John husbandman 586300 586300 Lote, John, of Wykhambroke, husbandman 0
3894066 1988232 1988232 defendant Kyng Thomas husbandman 586300 586300 Kyng, Thomas, of Wykhambroke, husbandman 1
3904558 1991773 1991773 defendant Lote John yeoman 586300 586300 Lote, John, of Wykhambroke, yeoman 2
3904559 1991773 1991773 defendant Ponde William smith 586300 586300 Ponde, William, of Wykhambroke, smith 3
3918556 1996533 1996533 defendant Parman John yeoman 586300 586300 Parman, John, of Wykhambroke, yeoman 0
4457737 2187432 2187432 defendant Coupere John   586300 586300 Coupere, John, of Wykhambroke 0
4787887 2292278 2292278 defendant Goldyng William yeoman 586300 586300 Goldyng, William, of Wykhambroke, yeoman 0
4787891 2292280 2292280 defendant Goulde John esq 586300 586300 Goulde, John, of Wykhambroke, esq 0
4812348 2299975 2299975 defendant Haukyn John husbandman 586300 586300 Haukyn, John, of Wykhambroke, husbandman 4
4846299 2310347 2310347 defendant Borse Richard butcher 586300 586300 Borse, Richard, of Wykhambroke, butcher 1
4926501 2334706 2334706 defendant Motte Thomas husbandman 586300 586300 Motte, Thomas, of Wykhambroke, husbandman 4
5079085 2380233 2380233 defendant Broun Richard woolman 586300 586300 Broun, Richard, of Wykhambroke, woolman 1
5092016 2384043 2384043 defendant Parre John yeoman 586300 586300 Parre, John, of Wykhambroke, yeoman 4
5106860 2388433 2388433 defendant Mot John merchant 586300 586300 Mot, John, of Wykhambroke, merchant 0
5255079 2431701 2431701 defendant Wurlyche alias Fleccher William yeoman 586300 586300 Wurlyche alias Fleccher, William, of Wykhambroke, yeoman 1
5504509 2506332 2506332 defendant Parman Thomas husbandman 586300 586300 Parman, Thomas, of Wykhambroke, husbandman 0
5504510 2506332 2506332 defendant Kynge John butcher 586300 586300 Kynge, John, of Wykhambroke, butcher 1
5505242 2506550 2506550 defendant Mott Thomas laborer 586300 586300 Mott, Thomas, of Wykhambroke, laborer 1
5521500 2511539 2511539 defendant Motte Robert husbandman 586300 586300 Motte, Robert, of Wykhambroke, husbandman 3
5534857 2515443 2515443 defendant Bateman Thomas, senior (legal representative) 586300 586300 Bateman, Thomas, senior, of Wykhambroke, husbandman, executor of 0
5534858 2515443 2515443 defendant Bateman William, senior husbandman 586300 586300 Bateman, William, senior, of Wykhambroke, husbandman 1
5549746 2519957 2519957 defendant Pery John husbandman 586300 586300 Pery, John, of Wykhambroke, husbandman 3
5549747 2519957 2519957 defendant Lote William husbandman 586300 586300 Lote, William, of Wykhambroke, husbandman 4
5553850 2521164 2521164 defendant Kyng John husbandman 586300 586300 Kyng, John, of Wykhambroke, husbandman 0
5563537 2523939 2523939 defendant Kyng John tanner 586300 586300 Kyng, John, of Wykhambroke, tanner 0
5589737 2531786 2531786 defendant Coteras John butcher 586300 586300 Coteras, John, of Wykhambroke, butcher 1
5589738 2531786 2531786 defendant Bateman John husbandman 586300 586300 Bateman, John, of Wykhambroke, husbandman 2
5605192 2536499 2536499 defendant Coteras John butcher 586300 586300 Coteras, John, of Wykhambroke, butcher 1
5605193 2536499 2536499 defendant Kyng John tanner 586300 586300 Kyng, John, of Wykhambroke, tanner 2

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);