names

48 rows where place_id = 586742

✎ 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
3589505 1864354 1864354 defendant Harawell John gent 586742 586742 Harawell, John, of Whitley, gent 0
3606446 1869684 1869684 defendant Pachet Henry husbandman 586742 586742 Pachet, Henry, of Whitley, husbandman 1
3607811 1870095 1870095 defendant Russhton Richard gent 586742 586742 Russhton, Richard, of Whitley, gent 1
3607844 1870103 1870103 defendant Russhton Richard gent 586742 586742 Russhton, Richard, of Whitley, gent 0
3607847 1870104 1870104 defendant Russhton Richard gent 586742 586742 Russhton, Richard, of Whitley, gent 0
3627422 1903432 1903432 defendant Grene William yeoman 586742 586742 Grene, William, of Whitley, yeoman 0
3638816 1906961 1906961 defendant Elynger Thomas yeoman 586742 586742 Elynger, Thomas, of Whitley, yeoman 0
3652349 1911070 1911070 defendant Elinger Thomas yeoman 586742 586742 Elinger, Thomas, of Whitley, yeoman 0
3681973 1920467 1920467 defendant Beamount Richard esq 586742 586742 Beamount, Richard, of Whitley, esq 0
3691995 1923661 1923661 defendant Grene William yeoman 586742 586742 Grene, William, of Whitley, yeoman 0
3702843 1927162 1927162 defendant Beamont Richard esq 586742 586742 Beamont, Richard, of Whitley, esq 0
3764638 1946602 1946602 defendant Wryght Alexander yeoman 586742 586742 Wryght, Alexander, of Whitley, yeoman 0
3782648 1952314 1952314 defendant Wryght Alexander yeoman 586742 586742 Wryght, Alexander, of Whitley, yeoman 0
3796543 1956792 1956792 defendant More Thomas husbandman 586742 586742 More, Thomas, of Whitley, husbandman 1
3796547 1956793 1956793 defendant Kyng John husbandman 586742 586742 Kyng, John, of Whitley, husbandman 2
3840692 1970653 1970653 defendant Starkye William gent 586742 586742 Starkye, William, of Whitley, gent 0
3871161 1980608 1980608 defendant Starkie William gent 586742 586742 Starkie, William, of Whitley, gent 0
3883994 1984916 1984916 defendant Goddert Richard yeoman 586742 586742 Goddert, Richard, of Whitley, yeoman 0
3883995 1984916 1984916 defendant Wood John yeoman 586742 586742 Wood, John, of Whitley, yeoman 1
4005209 2026642 2026642 plaintiff Kente Andrew yeoman 586742 586742 Kente, Andrew, of Whitley, yeoman 0
4005211 2026643 2026643 plaintiff Kente Andrew yeoman 586742 586742 Kente, Andrew, of Whitley, yeoman 0
4014151 2029790 2029790 defendant Kaye George yeoman 586742 586742 Kaye, George, of Whitley, yeoman 0
4073415 2050777 2050777 defendant Burdus Robert husbandman 586742 586742 Burdus, Robert, of Whitley, husbandman 0
4075802 2051645 2051645 defendant Kaye George gent or yeoman 586742 586742 Kaye, George, of Whitley, gent or yeoman 0
4075806 2051646 2051646 defendant Kaye George gent or yeoman 586742 586742 Kaye, George, of Whitley, gent or yeoman 0
4116529 2066200 2066200 defendant Pante or Paute John yeoman 586742 586742 Pante or Paute, John, of Whitley, yeoman 2
4128536 2070495 2070495 defendant Kay George gent 586742 586742 Kay, George, of Whitley, gent 3
4135850 2073153 2073153 defendant Kay George yeoman 586742 586742 Kay, George, of Whitley, yeoman 0
4138914 2074289 2074289 defendant Savyle Thomas gent 586742 586742 Savyle, Thomas, of Whitley, gent 5
4211386 2099536 2099536 plaintiff Twystleton Richard (legal representative) 586742 586742 Twystleton, Richard, of Whitley, tanner, executors of 0
4215102 2100784 2100784 defendant Parker Francis tanner 586742 586742 Parker, Francis, of Whitley, tanner 0
4221318 2102953 2102953 defendant Carre Thomas cutler 586742 586742 Carre, Thomas, of Whitley, yeoman, cutler 2
4335436 2142123 2142123 defendant Savile Thomas gent 586742 586742 Savile, Thomas, of Whitley, gent 0
4776566 2288664 2288664 defendant Moyne William husbandman 586742 586742 Moyne, William, of Whitley, husbandman 0
4777161 2288840 2288840 defendant Skette Henry   586742 586742 Skette, Henry, of Whitley, mason 0
4872106 2318237 2318237 defendant Halle Thomas chaplain 586742 586742 Halle, Thomas, of Whitley, chaplain 0
4872120 2318241 2318241 defendant Halle Thomas chaplain 586742 586742 Halle, Thomas, of Whitley, chaplain 0
4895875 2325376 2325376 defendant Pierson William husbandman 586742 586742 Pierson, William, of Whitley, husbandman 5
4984299 2352230 2352230 defendant Knotton Henry husbandman 586742 586742 Knotton, Henry, of Whitley, husbandman 0
4988507 2353522 2353522 defendant Skalwra Thomas yeoman 586742 586742 Skalwra, Thomas, of Whitley, yeoman 7
4995474 2355488 2355488 defendant Skalwra Thomas yeoman 586742 586742 Skalwra, Thomas, of Whitley, yeoman 7
5005501 2358511 2358511 defendant Skalwra Thomas yeoman 586742 586742 Skalwra, Thomas, of Whitley, yeoman 7
5047370 2370831 2370831 defendant Westby John gent 586742 586742 Westby, John, of Whitley, gent 1
5263462 2434319 2434319 defendant Tykhyll John husbandman 586742 586742 Tykhyll, John, of Whitley, husbandman 2
5263463 2434319 2434319 defendant Wylson John husbandman 586742 586742 Wylson, John, of Whitley, husbandman 3
5351258 2460486 2460486 defendant Middilton Stephen husbandman 586742 586742 Middilton, Stephen, of Whitley, husbandman 0
5501222 2505322 2505322 defendant Whitley Robert gent 586742 586742 Whitley, Robert, of Whitley, gent 0
5550445 2520150 2520150 defendant Wawen John miller 586742 586742 Wawen, John, of Whitley, miller 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);