names

37 rows where place_id = 610776

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3685104 1921486 1921486 defendant Randolf Thomas husbandman 610776 610776 Randolf, Thomas, of Stodham, husbandman 0
3685106 1921487 1921487 defendant Randolf Thomas husbandman 610776 610776 Randolf, Thomas, of Stodham, husbandman 0
3685835 1921727 1921727 defendant Robertys Thomas laborer 610776 610776 Robertys, Thomas, of Stodham, laborer 2
3689774 1922958 1922958 defendant Carter Thomas laborer 610776 610776 Carter, Thomas, of Stodham, laborer 0
3703688 1927434 1927434 defendant Elym or Glym John butcher 610776 610776 Elym or Glym, John, of Stodham, butcher 2
3717550 1931779 1931779 defendant Glyn John butcher 610776 610776 Glyn, John, of Stodham, butcher 0
3766404 1947149 1947149 defendant Bemonde William husbandman 610776 610776 Bemonde, William, of Stodham, husbandman 0
3891710 1987485 1987485 defendant Stacy John husbandman 610776 610776 Stacy, John, of Stodham, husbandman 0
3891711 1987485 1987485 defendant Barnes John husbandman 610776 610776 Barnes, John, of Stodham, husbandman 1
3891713 1987486 1987486 defendant Wever Thomas husbandman 610776 610776 Wever, Thomas, of Stodham, husbandman 0
3891715 1987487 1987487 defendant Wever Thomas husbandman 610776 610776 Wever, Thomas, of Stodham, husbandman 0
3891716 1987487 1987487 defendant Stacy John husbandman 610776 610776 Stacy, John, of Stodham, husbandman 1
3891717 1987487 1987487 defendant Barnes John husbandman 610776 610776 Barnes, John, of Stodham, husbandman 2
3891718 1987487 1987487 defendant Byrde John husbandman 610776 610776 Byrde, John, of Stodham, husbandman 3
3891719 1987487 1987487 defendant Quatermayns John husbandman 610776 610776 Quatermayns, John, of Stodham, husbandman 4
4509320 2203390 2203390 plaintiff Stokshull Richard   610776 610776 Stokshull, Richard, of Stodham 3
4538946 2212453 2212453 defendant Janyn William   610776 610776 Janyn, William, of Stodham 0
4538948 2212454 2212454 defendant Janyn William   610776 610776 Janyn, William, of Stodham 0
4538949 2212454 2212454 defendant Stokeshill Richard   610776 610776 together with Stokeshill, Richard, of Stodham 1
4538950 2212454 2212454 defendant atte Felde Clement   610776 610776 atte Felde, Clement, of Stodham 2
4538951 2212454 2212454 defendant atte Lane Richard   610776 610776 atte Lane, Richard, of Stodham 3
4538955 2212454 2212454 defendant atte Welle Richard   610776 610776 atte Welle, Richard, of Stodham 7
4538957 2212455 2212455 defendant Stokeshill Richard   610776 610776 Stokeshill, Richard, of Stodham 0
4538958 2212455 2212455 defendant atte Felde Clement   610776 610776 atte Felde, Clement, of Stodham 1
4538959 2212455 2212455 defendant atte Lane Richard   610776 610776 atte Lane, Richard, of Stodham 2
4538963 2212456 2212456 defendant Stokeshill Richard   610776 610776 Stokeshill, Richard, of Stodham 0
4538964 2212456 2212456 defendant atte Felde Clement   610776 610776 atte Felde, Clement, of Stodham 1
4538965 2212456 2212456 defendant atte Lane Richard   610776 610776 atte Lane, Richard, of Stodham 2
4538969 2212456 2212456 defendant atte Walle Ralph   610776 610776 atte Walle, Ralph, of Stodham 6
4538970 2212456 2212456 defendant Janyn William   610776 610776 Janyn, William, of Stodham 7
4603961 2232411 2232411 defendant Janyn William   610776 610776 Janyn, William, of Stodham 0
4817419 2301536 2301536 defendant Sprewele William husbandman 610776 610776 Sprewele, William, of Stodham, husbandman 0
5079490 2380358 2380358 defendant Heyward Richard husbandman 610776 610776 Heyward, Richard, of Stodham, husbandman 1
5079496 2380359 2380359 defendant Hayward Richard husbandman 610776 610776 Hayward, Richard, of Stodham, husbandman 1
5090077 2383469 2383469 defendant Sarney or Sarvey Peter husbandman 610776 610776 Sarney or Sarvey, Peter, of Stodham, husbandman 0
5148938 2400818 2400818 defendant Aylyng Michale   610776 610776 Aylyng, Michale, of Stodham, mill ward 0
5327465 2453283 2453283 defendant Heth John husbandman 610776 610776 Heth, John, of Stodham, husbandman 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);