names

35 rows where place_id = 742412

✎ 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
4314190 2135070 2135070 defendant Stutt Leonard yeoman 742412 742412 Stutt, Leonard, of Bilton, or of Sutcotes in Holdernes, yeoman 1
4350149 2147310 2147310 defendant Marston Edward yeoman 742412 742412 Marston, Edward, of Bilton, yeoman 0
4430606 2174326 2174326 plaintiff Yoten John   742412 742412 Yoten, John, of Bilton 0
4480980 2194728 2194728 defendant West John   742412 742412 West, John, of Bilton 1
4525439 2208291 2208291 defendant Clerk Thomas   742412 742412 Clerk, Thomas, of Bilton 0
4572015 2222814 2222814 defendant Swynton William   742412 742412 Swynton, William, of Bilton 2
4588742 2227860 2227860 plaintiff Lambthorp Adam de   742412 742412 Lambthorp, Adam de, of Bilton 0
4594655 2229582 2229582 defendant Normanby John   742412 742412 Normanby, John, of Bilton 5
4600411 2231354 2231354 defendant Taillour Ralph   742412 742412 Taillour, Ralph, of Bilton 0
4673698 2257402 2257402 defendant Daynyll Thomas gent 742412 742412 Daynyll, Thomas, of Bilton, gent 3
4679417 2259179 2259179 defendant Donfeson or Doufeson Thomas husbandman 742412 742412 Donfeson or Doufeson, Thomas, of Bilton, husbandman 0
4680314 2259455 2259455 defendant Sherman John tailor 742412 742412 Sherman, John, of Bilton, tailor 0
4694717 2263844 2263844 defendant Doweson Thomas yeoman 742412 742412 Doweson, Thomas, of Bilton, yeoman 0
4697222 2264612 2264612 plaintiff Clerk William (legal representative) 742412 742412 Clerk, William, of Bilton, chaplain, executors of 0
4697225 2264612 2264612 defendant Symson Ralph husbandman 742412 742412 Symson, Ralph, of Bilton, husbandman 0
4719570 2271462 2271462 defendant Symson John laborer 742412 742412 Symson, John, of Bilton, laborer 0
4719571 2271462 2271462 defendant Mychell Thomas laborer 742412 742412 Mychell, Thomas, of Bilton, laborer 1
4719572 2271462 2271462 defendant Jakson William laborer 742412 742412 Jakson, William, of Bilton, laborer 2
4720490 2271746 2271746 defendant Mortayn Robert husbandman 742412 742412 Mortayn, Robert, of Bilton, husbandman 0
4727369 2273809 2273809 defendant Mortayne Robert gent 742412 742412 Mortayne, Robert, of Bilton, gent 0
4974862 2349451 2349451 defendant Graunge John husbandman 742412 742412 Graunge, John, of Bilton, husbandman 4
5087051 2382594 2382594 plaintiff Holme John   742412 742412 Holme, John, of Bilton 0
5163879 2405171 2405171 plaintiff Worsley John   742412 742412 Worsley, John, of Bilton, parson, rector & clerk 0
5163880 2405171 2405171 defendant Pedefer William   742412 742412 Pedefer, William, of Bilton, franklin 0
5537924 2516353 2516353 plaintiff Daynell Thomas esq 742412 742412 Daynell, Thomas, of Bilton, esq 0
5602271 2535602 2535602 defendant Bilby James husbandman 742412 742412 Bilby, James, of Bilton, husbandman 1
5602274 2535603 2535603 defendant Bilby James husbandman 742412 742412 Bilby, James, of Bilton, husbandman 1
5602277 2535604 2535604 defendant Bilby James husbandman 742412 742412 Bilby, James, of Bilton, husbandman 1
5604568 2536288 2536288 defendant Pershey Percival gent 742412 742412 Pershey, Percival, of Bilton, gent 0
5624690 2551656 2551656 defendant Fox Richard husbandman 742412 742412 Fox, Richard, of Bilton, husbandman 0
5624693 2551657 2551657 defendant Louther William husbandman 742412 742412 Louther, William, of Bilton, husbandman 0
5624694 2551657 2551657 defendant de Foleby John husbandman 742412 742412 de Foleby, John, of Bilton, husbandman 1
5624731 2551667 2551667 defendant Sherman John tailor 742412 742412 Sherman, John, of Bilton, tailor 0
5633658 2554526 2554526 defendant Daneson or Daveson Thomas husbandman 742412 742412 Daneson or Daveson, Thomas, of Bilton, husbandman 0
5633659 2554526 2554526 defendant Houson William husbandman 742412 742412 Houson, William, of Bilton, 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);