names

39 rows where place_id = 613545

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3698940 1925880 1925880 defendant Crychelove Ralph brewer 613545 613545 Crychelove, Ralph, of West Grensted, brewer 5
3698942 1925880 1925880 defendant Gyllam Richard laborer 613545 613545 Gyllam, Richard, of West Grensted, laborer 7
3698943 1925880 1925880 defendant Cateryke Thomas laborer 613545 613545 Cateryke, Thomas, of West Grensted, laborer 8
3770238 1948359 1948359 defendant Person Henry husbandman 613545 613545 Person, Henry, of West Grensted, husbandman 0
3788025 1954046 1954046 defendant Peerson Henry husbandman 613545 613545 Peerson, Henry, of West Grensted, husbandman 0
3788029 1954047 1954047 defendant Peerson Henry husbandman 613545 613545 Peerson, Henry, of West Grensted, husbandman 0
3908166 1993029 1993029 defendant Hychecok Michael husbandman 613545 613545 Hychecok, Michael, of West Grensted, husbandman 0
3908167 1993029 1993029 defendant Lynfeld Henry husbandman 613545 613545 Lynfeld, Henry, of West Grensted, husbandman 1
3918002 1996388 1996388 defendant Herryott William husbandman 613545 613545 Herryott, William, of West Grensted, husbandman 1
4022858 2032899 2032899 plaintiff Bacon Salamon   613545 613545 Bacon, Salamon, of West Grensted 0
4022860 2032900 2032900 plaintiff Bacon Salomon   613545 613545 Bacon, Salomon, of West Grensted 0
4066315 2048242 2048242 defendant Wolvyn John laborer 613545 613545 Wolvyn, John, of West Grensted, laborer 1
4076373 2051848 2051848 defendant Hooker John husbandman 613545 613545 Hooker, John, of West Grensted, husbandman 0
4076374 2051848 2051848 defendant Penycod George husbandman 613545 613545 Penycod, George, of West Grensted, husbandman 1
4076375 2051848 2051848 defendant Allen Richard husbandman 613545 613545 Allen, Richard, of West Grensted, husbandman 2
4076377 2051849 2051849 defendant Hooker John husbandman 613545 613545 Hooker, John, of West Grensted, husbandman 0
4076378 2051849 2051849 defendant Penycod George husbandman 613545 613545 Penycod, George, of West Grensted, husbandman 1
4076379 2051849 2051849 defendant Allen Richard husbandman 613545 613545 Allen, Richard, of West Grensted, husbandman 2
4107972 2063123 2063123 defendant Gratewyck John yeoman 613545 613545 Gratewyck, John, of West Grensted, yeoman 0
4107974 2063124 2063124 defendant Gratewick John yeoman 613545 613545 Gratewick, John, of West Grensted, yeoman 0
4173868 2086315 2086315 defendant Waterman Thomas husbandman 613545 613545 Waterman, Thomas, of West Grensted, husbandman 1
4179493 2088305 2088305 defendant Gate John husbandman 613545 613545 Gate John, of West Grensted, husbandman, executors of 0
4368142 2153660 2153660 defendant Pepper John yeoman 613545 613545 Pepper, John, of West Grensted, yeoman 0
4368143 2153660 2153660 defendant Conte or Coute John yeoman 613545 613545 Conte or Coute, John, of West Grensted, yeoman 1
4368144 2153660 2153660 defendant Maskewe John yeoman 613545 613545 Maskewe, John, of West Grensted, yeoman 2
4368145 2153660 2153660 defendant Pyllett William yeoman 613545 613545 Pyllett, William, of West Grensted, yeoman 3
4618204 2236702 2236702 plaintiff Halsham John   613545 613545 Halsham, John, of West Grensted 0
4720186 2271658 2271658 defendant Hemery John laborer 613545 613545 Hemery, John, of West Grensted, laborer 0
4748339 2280019 2280019 defendant Clothale Richard gent 613545 613545 Clothale, Richard, of West Grensted, gent 0
4876452 2319597 2319597 defendant Blachmerden Richard husbandman 613545 613545 Blachmerden, Richard, of West Grensted, husbandman 0
4897402 2325847 2325847 defendant Lane Thomas laborer 613545 613545 Lane, Thomas, of West Grensted, laborer 0
4897403 2325847 2325847 defendant Blaunche John cordwainer 613545 613545 Blaunche, John, of West Grensted, cordwainer 1
4938554 2338440 2338440 defendant Lane Thomas husbandman 613545 613545 Lane, Thomas, of West Grensted, husbandman 0
4938782 2338518 2338518 defendant atte Hamme Thomas husbandman 613545 613545 atte Hamme, Thomas, of West Grensted, husbandman 0
5004660 2358265 2358265 defendant atte Hamme Thomas husbandman 613545 613545 atte Hamme, Thomas, of West Grensted, husbandman 0
5037513 2367842 2367842 defendant Stydolf George gent 613545 613545 Stydolf, George, of West Grensted, gent 0
5114274 2390568 2390568 defendant Lyndefeld John   613545 613545 Lyndefeld, John, of West Grensted, millward 0
5482510 2499711 2499711 defendant Person Thomas butcher 613545 613545 Person, Thomas, of West Grensted, butcher 1
5482511 2499711 2499711 defendant Davy Roger carpenter 613545 613545 Davy, Roger, of West Grensted, carpenter 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);