names

32 rows where place_id = 594333

✎ 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
3615630 1872530 1872530 defendant Baully Robert husbandman 594333 594333 Baully, Robert, of Nether Wallop, husbandman 0
3638005 1906703 1906703 defendant Gerle Thomas husbandman 594333 594333 Gerle, Thomas, of Nether Wallop, husbandman 0
3638006 1906703 1906703 defendant West Thomas husbandman 594333 594333 West, Thomas, of Nether Wallop, husbandman 1
3638007 1906703 1906703 defendant Heyes John   594333 594333 Heyes, John, of Nether Wallop, parish clerk 2
3638008 1906703 1906703 defendant Hough John husbandman 594333 594333 Hough, John, of Nether Wallop, husbandman 3
4225154 2104268 2104268 defendant Reade Nicholas (legal representative) 594333 594333 Reade, Nicholas, of Nether Wallop, yeoman, executors of 0
4606859 2233254 2233254 defendant Canys Richard   594333 594333 Canys, Richard, of Nether Wallop 0
4728745 2274227 2274227 defendant Crook John clerk 594333 594333 Crook, John, of Nether Wallop, clerk 0
4771616 2287100 2287100 defendant Basset John husbandman 594333 594333 Basset, John, of Nether Wallop, husbandman 0
4771617 2287100 2287100 defendant Flyngedewe John husbandman 594333 594333 Flyngedewe, John, of Nether Wallop, husbandman 1
4782901 2290671 2290671 plaintiff Crook John   594333 594333 Crook, John, of Nether Wallop 0
4799794 2296120 2296120 defendant Flyngedywe John husbandman 594333 594333 Flyngedywe, John, of Nether Wallop, husbandman 0
4886233 2322556 2322556 defendant Jonys William shoemaker 594333 594333 Jonys, William, of Nether Wallop, shoemaker 0
4888565 2323223 2323223 defendant Fenton William clerk 594333 594333 Fenton, William, of Nether Wallop, clerk 0
4892145 2324285 2324285 defendant Baldyng Thomas husbandman 594333 594333 Baldyng, Thomas, of Nether Wallop, husbandman 0
4908957 2329345 2329345 defendant Gyne or Gyve Robert husbandman 594333 594333 Gyne or Gyve, Robert, of Nether Wallop, husbandman 0
4931839 2336344 2336344 defendant Ombe John husbandman 594333 594333 Ombe, John, of Nether Wallop, husbandman 3
4950348 2342074 2342074 defendant Waleys William weaver 594333 594333 Waleys, William, of Nether Wallop, weaver 2
4972755 2348787 2348787 defendant Jonys William cordwainer 594333 594333 Jonys, William, of Nether Wallop, cordwainer 0
4972757 2348788 2348788 defendant Jonys William cordwainer 594333 594333 Jonys, William, of Nether Wallop, cordwainer 0
4983542 2351993 2351993 defendant Purdewe Robert husbandman 594333 594333 Purdewe, Robert, of Nether Wallop, husbandman 0
5000632 2357054 2357054 defendant Dewy Philip smith 594333 594333 Dewy, Philip, of Nether Wallop, smith 0
5019968 2362721 2362721 defendant Smyth Thomas laborer 594333 594333 Smyth, Thomas, of Nether Wallop, laborer 0
5026510 2364634 2364634 defendant Joon William butcher 594333 594333 Joon, William, of Nether Wallop, butcher 0
5101833 2386958 2386958 defendant Gerle John laborer 594333 594333 Gerle, John, of Nether Wallop, laborer 0
5244057 2428450 2428450 defendant Dewy Richard husbandman 594333 594333 Dewy, Richard, of Nether Wallop, husbandman 0
5293747 2443132 2443132 defendant Geryll Thomas laborer 594333 594333 Geryll, Thomas, of Nether Wallop, laborer 0
5313582 2449091 2449091 defendant Hachard William butcher 594333 594333 Hachard, William, of Nether Wallop, butcher 5
5315780 2449792 2449792 defendant Blake John gent 594333 594333 Blake, John, of Nether Wallop, gent 0
5349737 2460054 2460054 defendant Gerle Thomas fisher 594333 594333 Gerle, Thomas, of Nether Wallop, fisher 2
5359585 2463033 2463033 defendant Baret John husbandman 594333 594333 Baret, John, of Nether Wallop, husbandman 1
5503547 2506024 2506024 defendant Donet or Dovet Robert husbandman 594333 594333 Donet or Dovet, Robert, of Nether Wallop, husbandman 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);