names

34 rows where place_id = 599056

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3635012 1905748 1905748 defendant Cokerell John husbandman 599056 599056 Cokerell, John, of Stysted, husbandman 3
3654497 1911666 1911666 defendant May John yeoman 599056 599056 May, John, of Stysted, yeoman 0
3678499 1919333 1919333 defendant Porter Joan widow 599056 599056 Porter, Joan, of Stysted, widow 0
3678500 1919333 1919333 defendant Porter John yeoman 599056 599056 Porter, John, of Stysted, yeoman 1
3701409 1926689 1926689 defendant Wheler John husbandman 599056 599056 Wheler, John, of Stysted, husbandman 0
3708780 1929041 1929041 defendant Sparowe Richard tanner 599056 599056 Sparowe, Richard, of Stysted, tanner 1
3708781 1929041 1929041 defendant Gauge John laborer 599056 599056 Gauge, John, of Stysted, laborer 2
3722301 1933237 1933237 plaintiff Maye John   599056 599056 Maye, John, of Stysted 0
3734041 1936895 1936895 defendant Bragge William yeoman 599056 599056 Bragge, William, of Stysted, yeoman 0
3752272 1942632 1942632 defendant Whiler John husbandman 599056 599056 Whiler, John, of Stysted, husbandman 0
3756714 1944073 1944073 defendant Edwarde Thomas miller 599056 599056 Edwarde, Thomas, of Stysted, miller 0
3756717 1944073 1944073 defendant Wheler John husbandman 599056 599056 Wheler, John, of Stysted, husbandman 3
3756718 1944073 1944073 defendant Tayllour John husbandman 599056 599056 Tayllour, John, of Stysted, husbandman 4
3763580 1946243 1946243 defendant Draper Robert   599056 599056 Draper, Robert, of Stysted, pale maker 2
3776132 1950278 1950278 defendant Wheler Thomas laborer 599056 599056 Wheler, Thomas, of Stysted, laborer 1
3786967 1953725 1953725 defendant Pryor Peter sherman 599056 599056 Pryor, Peter, of Stysted, sherman 2
3799413 1957737 1957737 defendant Holton John husbandman 599056 599056 (Holton, John, of Stysted, husbandman 3
3826533 1966146 1966146 defendant Burton John yeoman 599056 599056 Burton, John, of Stysted, yeoman 0
3833799 1968502 1968502 defendant Perlement alias Tarvell John butcher 599056 599056 Perlement alias Tarvell, John, of Stysted, butcher 1
3887403 1986050 1986050 defendant Coldam Robert   599056 599056 Coldam, Robert, of Stysted, horse courser 0
3906823 1992571 1992571 defendant Draper Richard husbandman 599056 599056 Draper, Richard, of Stysted, husbandman 0
3982846 2018638 2018638 defendant Kytchyn Richard clerk 599056 599056 Kytchyn, Richard, of Stysted, clerk 0
4454707 2186480 2186480 defendant Taillour Robert (legal representative) 599056 599056 Taillour, Robert, of Stysted, executrix of 0
4577375 2224439 2224439 defendant Kentyssh William   599056 599056 Kentyssh, William, of Stysted 0
4584803 2226677 2226677 defendant Smyth John   599056 599056 Smyth, John, of Stysted 0
4584804 2226677 2226677 defendant Talon John   599056 599056 Talon, John, of Stysted 1
4584805 2226677 2226677 defendant Whyte William   599056 599056 Whyte, William, of Stysted 2
4761992 2284097 2284097 defendant Prentys John fuller 599056 599056 Prentys, John, of Stysted, fuller 0
4803661 2297329 2297329 defendant Kyng John farmer 599056 599056 Kyng, John, of Stysted, farmer 2
4869735 2317503 2317503 defendant Clerk John   599056 599056 Clerk, John, of Stysted, ,mason 0
5071077 2377842 2377842 plaintiff Smyth John   599056 599056 Smyth, John, of Stysted 0
5249812 2430059 2430059 defendant Reyson John fuller 599056 599056 Reyson, John, of Stysted, fuller 0
5326719 2453058 2453058 defendant Gange or Gauge Thomas laborer 599056 599056 Gange or Gauge, Thomas, of Stysted, laborer 0
5340954 2457368 2457368 defendant Acreman John, junior husbandman 599056 599056 Acreman, John, junior, of Stysted, husbandman 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);