names

61 rows where place_id = 593267

✎ 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
3611126 1871154 1871154 defendant Hygyns Richard husbandman 593267 593267 Hygyns, Richard, of Longedon, husbandman 1
3937146 2002755 2002755 defendant Harcourt Simon esq 593267 593267 Harcourt, Simon, of Longedon, esq 0
4035601 2037407 2037407 defendant Ridgeley Anthony gent 593267 593267 Ridgeley, Anthony, of Longedon, gent 1
4035605 2037408 2037408 defendant Ridgeley Anthony gent 593267 593267 Ridgeley, Anthony, of Longedon, gent 1
4452456 2185765 2185765 plaintiff Kel William de miller 593267 593267 Kel, William de, of Longedon, miller 0
4466290 2190116 2190116 defendant Gem or Eem John   593267 593267 Gem or Eem, John, of Longedon 0
4466777 2190276 2190276 plaintiff Arblaster James   593267 593267 Arblaster, James, of Longedon 0
4466779 2190277 2190277 plaintiff Arblaster James   593267 593267 Arblaster, James, of Longedon 0
4472946 2192213 2192213 plaintiff Coudeler Thomas   593267 593267 Coudeler, Thomas, of Longedon 0
4509306 2203386 2203386 defendant Halcy Nicholas   593267 593267 Halcy, Nicholas, of Longedon 0
4509471 2203429 2203429 defendant atte Hull Richard   593267 593267 atte Hull, Richard, of Longedon 0
4513644 2204695 2204695 defendant Gybons John   593267 593267 Gybons, John, of Longedon 1
4539170 2212506 2212506 defendant Smyth John farmer 593267 593267 Smyth, John, of Longedon, farmer 0
4543002 2213705 2213705 plaintiff Aston John   593267 593267 Aston, John, of Longedon 1
4553664 2217072 2217072 plaintiff Gile John   593267 593267 Gile, John, of Longedon 0
4554394 2217303 2217303 defendant Bayly Walter   593267 593267 Bayly, Walter, of Longedon 0
4556418 2217946 2217946 defendant Pagon John   593267 593267 Pagon, John, of Longedon 0
4605739 2232912 2232912 plaintiff Aston John   593267 593267 Aston, John, of Longedon 0
4608706 2233828 2233828 defendant Shepherd John   593267 593267 Shepherd, John, of Longedon 1
4609287 2234006 2234006 defendant Cook Alice   593267 593267 Cook, Alice, of Longedon 0
4617451 2236470 2236470 plaintiff Grafton Robert   593267 593267 Grafton, Robert, of Longedon, vicar 0
4637636 2242556 2242556 plaintiff Brocton John   593267 593267 Brocton, John, of Longedon 0
4655255 2247529 2247529 plaintiff Brocton John   593267 593267 Brocton, John, of Longedon 0
4655258 2247530 2247530 plaintiff Brocton John   593267 593267 Brocton, John, of Longedon 0
4700336 2265521 2265521 defendant Waxman Thomas yeoman 593267 593267 Waxman, Thomas, of Longedon, yeoman 2
4700341 2265522 2265522 defendant Waxman Thomas yeoman 593267 593267 Waxman, Thomas, of Longedon, yeoman 2
4706576 2267435 2267435 plaintiff Lyot Thomas   593267 593267 Lyot, Thomas, of Longedon, vicar 0
4718849 2271239 2271239 defendant Handres William   593267 593267 Handres, William, of Longedon 0
4718850 2271239 2271239 defendant Croos Hugh husbandman 593267 593267 Croos, Hugh, of Longedon, husbandman 1
4718851 2271239 2271239 defendant Adams Philip husbandman 593267 593267 Adams, Philip, of Longedon, husbandman 2
4718852 2271239 2271239 defendant Adams Richard husbandman 593267 593267 Adams, Richard, of Longedon, husbandman 3
4718853 2271239 2271239 defendant Robyns Richard husbandman 593267 593267 Robyns, Richard, of Longedon, husbandman 4
4720696 2271806 2271806 defendant Bracton Richard yeoman 593267 593267 Bracton, Richard, of Longedon, yeoman 0
4761085 2283819 2283819 defendant Shepherd Robert husbandman 593267 593267 Shepherd, Robert, of Longedon, husbandman 0
4779806 2289680 2289680 plaintiff Brocton John   593267 593267 Brocton, John, of Longedon 0
4836597 2307417 2307417 defendant Eliot John husbandman alias clerk 593267 593267 Eliot, John, of Longedon, husbandman alias clerk 0
4844846 2309912 2309912 defendant Fletcher John husbandman 593267 593267 Fletcher, John, of Longedon, husbandman 4
4881853 2321223 2321223 defendant Holdye John husbandman 593267 593267 Holdye, John, of Longedon, husbandman 0
4916280 2331599 2331599 defendant Northende William husbandman 593267 593267 Northende, William, of Longedon, husbandman 0
4916281 2331599 2331599 defendant Northende John laborer 593267 593267 Northende, John, of Longedon, laborer 1
4936883 2337912 2337912 defendant Hancokes William husbandman 593267 593267 Hancokes, William, of Longedon, husbandman 1
4961673 2345455 2345455 defendant Campeden Nicholas husbandman 593267 593267 Campeden, Nicholas, of Longedon, husbandman 2
4973911 2349160 2349160 defendant Haukys Richard husbandman 593267 593267 Haukys, Richard, of Longedon, husbandman 0
5028719 2365276 2365276 defendant Blakelowe Robert husbandman 593267 593267 Blakelowe, Robert, of Longedon, husbandman 2
5028720 2365276 2365276 defendant Mascot William husbandman 593267 593267 Mascot, William, of Longedon, husbandman 3
5147775 2400491 2400491 defendant Holdy John husbandman 593267 593267 Holdy, John, of Longedon, husbandman 0
5176093 2408694 2408694 defendant Estyngton William gent 593267 593267 Estyngton, William, of Longedon, gent 0
5176094 2408694 2408694 defendant Holde William husbandman 593267 593267 Holde, William, of Longedon, husbandman 1
5176095 2408694 2408694 defendant Burford Walter laborer 593267 593267 Burford, Walter, of Longedon, laborer 2
5258544 2432789 2432789 defendant Osseberne John yeoman 593267 593267 Osseberne, John, of Longedon, yeoman 0
5258545 2432789 2432789 defendant Boteler John yeoman 593267 593267 Boteler, John, of Longedon, yeoman 1
5320124 2451107 2451107 defendant Hancokkes Robert husbandman 593267 593267 Hancokkes, Robert, of Longedon, husbandman 2
5368868 2465851 2465851 defendant Lichefeld Joan widow 593267 593267 Lichefeld, Joan, of Longedon, widow 2
5434022 2485129 2485129 defendant Meeston John husbandman 593267 593267 Meeston, John, of Longedon, husbandman 0
5461681 2493433 2493433 defendant Meeston John husbandman 593267 593267 Meeston, John, of Longedon, husbandman 0
5473223 2496952 2496952 defendant Meeston John husbandman 593267 593267 Meeston, John, of Longedon, husbandman 0
5483854 2500115 2500115 defendant Crosse Hugh husbandman 593267 593267 Crosse, Hugh, of Longedon, husbandman 1
5534426 2515309 2515309 defendant Riggeley Richard gent 593267 593267 Riggeley, Richard, of Longedon, gent 0
5596661 2533877 2533877 defendant Hylle Thomas husbandman 593267 593267 Hylle, Thomas, of Longedon, husbandman 0
5597229 2534042 2534042 defendant Cowper Richard yeoman 593267 593267 Cowper, Richard, of Longedon, yeoman 0
5597231 2534043 2534043 defendant Cowper Richard yeoman 593267 593267 Cowper, Richard, of Longedon, yeoman 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);