names

45 rows where place_id = 595816

✎ 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
3622012 1874426 1874426 defendant Payn Robert yeoman 595816 595816 Payn, Robert, of Wympole, yeoman 1
3656542 1912299 1912299 defendant Fyncham William clerk 595816 595816 Fyncham, William, of Wympole, clerk 0
3671320 1917004 1917004 defendant Mysden Robert husbandman 595816 595816 Mysden, Robert, of Wympole, husbandman 0
3715294 1931071 1931071 defendant Bery Thomas yeoman 595816 595816 Bery, Thomas, of Wympole, yeoman 1
3767070 1947360 1947360 defendant Bell John husbandman 595816 595816 Bell, John, of Wympole, husbandman 1
3784875 1953063 1953063 defendant Bell John husbandman 595816 595816 Bell, John, of Wympole, husbandman 1
3890101 1986923 1986923 defendant Day William husbandman 595816 595816 Day, William, of Wympole, husbandman 0
4573731 2223300 2223300 defendant Bunche William   595816 595816 Bunche, William, of Wympole 2
4637484 2242514 2242514 defendant Coulyng William   595816 595816 Coulyng, William, of Wympole 5
4652389 2246697 2246697 defendant Boufay John husbandman 595816 595816 Boufay, John, of Wympole, husbandman 0
4708744 2268105 2268105 defendant Bonfay John husbandman 595816 595816 Bonfay, John, of Wympole, husbandman 3
4773448 2287666 2287666 defendant Stenkyn John butcher 595816 595816 Stenkyn, John, of Wympole, butcher 1
4773451 2287666 2287666 defendant Coulyng Walter husbandman 595816 595816 Coulyng, Walter, of Wympole, husbandman 4
4773453 2287667 2287667 defendant Taunt John husbandman 595816 595816 Taunt, John, of Wympole, husbandman 0
4773454 2287667 2287667 defendant Pulton Thomas husbandman 595816 595816 Pulton, Thomas, of Wympole, husbandman 1
4811767 2299792 2299792 defendant Pato John husbandman 595816 595816 Pato, John, of Wympole, husbandman 0
4822868 2303235 2303235 defendant Haunser John husbandman 595816 595816 Haunser, John, of Wympole, husbandman 3
4860031 2314506 2314506 defendant Kyng john   595816 595816 Kyng, john, of Wympole 4
4912632 2330453 2330453 defendant Bouer John yeoman 595816 595816 Bouer, John, of Wympole, yeoman 4
4921185 2333143 2333143 plaintiff Kyng William   595816 595816 Kyng, William, of Wympole 0
4926258 2334637 2334637 defendant Bovesay or Bonesay John, senior husbandman 595816 595816 Bovesay or Bonesay, John, senior, of Wympole, husbandman 0
4972622 2348744 2348744 plaintiff Kyng William   595816 595816 Kyng, William, of Wympole 0
4972624 2348745 2348745 plaintiff Kyng William   595816 595816 Kyng, William, of Wympole 0
4991493 2354339 2354339 defendant Stampeyn Thomas   595816 595816 Stampeyn, Thomas, of Wympole 5
5056591 2373544 2373544 defendant Brewyn William yeoman 595816 595816 Brewyn, William, of Wympole, yeoman 0
5064007 2375767 2375767 defendant Love Thomas laborer 595816 595816 Love, Thomas, of Wympole, laborer 0
5101859 2386965 2386965 defendant Kirkham Robert clerk 595816 595816 Kirkham, Robert, of Wympole, clerk 0
5110489 2389471 2389471 defendant Brewyn William yeoman 595816 595816 Brewyn, William, of Wympole, yeoman 1
5144190 2399453 2399453 defendant Kyrkham Robert clerk & rector 595816 595816 Kyrkham, Robert, of Wympole, clerk & rector 0
5151635 2401634 2401634 defendant Boner Walter husbandman 595816 595816 Boner, Walter, of Wympole, husbandman 1
5151636 2401634 2401634 defendant Boner Nicholas husbandman 595816 595816 Boner, Nicholas, of Wympole, husbandman 2
5182656 2410681 2410681 defendant Stokes Walter chaplain 595816 595816 Stokes, Walter, of Wympole, chaplain 0
5186838 2411896 2411896 defendant Stokes Walter chaplain 595816 595816 Stokes, Walter, of Wympole, chaplain 0
5205373 2417326 2417326 defendant Stokes Walter chaplain 595816 595816 Stokes, Walter, of Wympole, chaplain 0
5229569 2424264 2424264 defendant Boner Nicholas husbandman 595816 595816 Boner, Nicholas, of Wympole, husbandman 1
5283478 2440220 2440220 defendant Freman Robert butcher 595816 595816 Freman, Robert, of Wympole, butcher 0
5283479 2440220 2440220 defendant Bonfay or Boufay John husbandman 595816 595816 Bonfay or Boufay, John, of Wympole, husbandman 1
5283480 2440220 2440220 defendant Maldon Henry husbandman 595816 595816 Maldon, Henry, of Wympole, husbandman 2
5283482 2440221 2440221 defendant Freman Robert butcher 595816 595816 Freman, Robert, of Wympole, butcher 0
5283483 2440221 2440221 defendant Boufay or Bonfay John husbandman 595816 595816 Boufay or Bonfay, John, of Wympole, husbandman 1
5283484 2440221 2440221 defendant Maldon Henry husbandman 595816 595816 Maldon, Henry, of Wympole, husbandman 2
5311821 2448562 2448562 defendant Payne Robert husbadman 595816 595816 Payne, Robert, of Wympole, husbadman 1
5370998 2466517 2466517 defendant Kynge John husbandman 595816 595816 Kynge, John, of Wympole, husbandman 0
5370999 2466517 2466517 defendant Haye William husbandman 595816 595816 Haye, William, of Wympole, husbandman 1
5516611 2510023 2510023 defendant Payne Robert yeoman 595816 595816 Payne, Robert, of Wympole, yeoman 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);