names

52 rows where place_id = 594337

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3615650 1872539 1872539 plaintiff Colybroke John   594337 594337 Colybroke, John, of Asshyll 0
3699796 1926161 1926161 defendant Englyssh John husbandman 594337 594337 Englyssh, John, of Asshyll, husbandman 1
3727330 1934822 1934822 defendant Englysshe John husbandman 594337 594337 Englysshe, John, of Asshyll, husbandman 1
3813899 1962258 1962258 defendant Johnson Nicholas butcher 594337 594337 Johnson, Nicholas, of Asshyll, butcher 0
3828163 1966676 1966676 plaintiff Canon John husbandman 594337 594337 Canon, John, of Asshyll, husbandman 0
3853802 1974822 1974822 defendant Wellys John thatcher 594337 594337 Wellys, John, of Asshyll, thatcher 0
3853803 1974822 1974822 defendant Deynes William husbandman 594337 594337 Deynes, William, of Asshyll, husbandman 1
3853804 1974822 1974822 defendant Heyhowe Robert husbandman 594337 594337 Heyhowe, Robert, of Asshyll, husbandman 2
3897659 1989427 1989427 defendant Stede Anne widow 594337 594337 Stede, Anne, of Asshyll, widow 1
3900575 1990423 1990423 defendant Candeler Robert husbandman 594337 594337 Candeler, Robert, of Asshyll, husbandman 0
3914468 1995181 1995181 defendant Thaxter Andrew husbandman 594337 594337 Thaxter, Andrew, of Asshyll, husbandman 0
3929532 2000226 2000226 plaintiff Canham John yeoman 594337 594337 Canham, John, of Asshyll, yeoman 0
4032607 2036311 2036311 defendant Cannon John, senior   594337 594337 Cannon, John, senior, of Asshyll 0
4121636 2068034 2068034 defendant Barefoote George yeoman 594337 594337 Barefoote, George, of Asshyll, yeoman 0
4656299 2247861 2247861 defendant Forbour John furbisher 594337 594337 Forbour, John, of Asshyll, furbisher 2
5018827 2362395 2362395 defendant Smyth Robert husbandman 594337 594337 Smyth, Robert, of Asshyll, husbandman 1
5042070 2369235 2369235 defendant Smyth Robert husbandman 594337 594337 Smyth, Robert, of Asshyll, husbandman 1
5217920 2420975 2420975 defendant Coo John husbandman 594337 594337 Coo, John, of Asshyll, husbandman 1
5293891 2443184 2443184 defendant Elyot Nicholas husbandman 594337 594337 Elyot, Nicholas, of Asshyll, husbandman 2
5301086 2445278 2445278 defendant Coo Richard husbandman 594337 594337 Coo, Richard, of Asshyll, husbandman 2
5309644 2447925 2447925 defendant Elyot Geoffrey husbandman 594337 594337 Elyot, Geoffrey, of Asshyll, husbandman 0
5314890 2449501 2449501 defendant Elyot Geoffrey husbandman 594337 594337 Elyot, Geoffrey, of Asshyll, husbandman 3
5321746 2451577 2451577 defendant Doket John husbandman 594337 594337 Doket, John, of Asshyll, husbandman 0
5328212 2453511 2453511 defendant Elyotte Geoffey husbandman 594337 594337 Elyotte, Geoffey, of Asshyll, husbandman 0
5380539 2469486 2469486 defendant Smyth Robert yeoman 594337 594337 Smyth, Robert, of Asshyll, yeoman 0
5381417 2469745 2469745 defendant Smyth Robert yeoman 594337 594337 Smyth, Robert, of Asshyll, yeoman 0
5381418 2469745 2469745 defendant Warde John, senior husbandman 594337 594337 Warde, John, senior, of Asshyll, husbandman 1
5385254 2470857 2470857 defendant Smyth Robert yeoman 594337 594337 Smyth, Robert, of Asshyll, yeoman 0
5388720 2471829 2471829 defendant Smyth Robert yeoman 594337 594337 Smyth, Robert, of Asshyll, yeoman 0
5388721 2471829 2471829 defendant Lysse Thomas yeoman 594337 594337 Lysse, Thomas, of Asshyll, yeoman 1
5388722 2471829 2471829 defendant Warde John, senior husbandman 594337 594337 Warde, John, senior, of Asshyll, husbandman 2
5401027 2475356 2475356 defendant Smyth Robert yeoman 594337 594337 Smyth, Robert, of Asshyll, yeoman 0
5401329 2475441 2475441 defendant Smyth Robert yeoman 594337 594337 Smyth, Robert, of Asshyll, yeoman 0
5401331 2475441 2475441 defendant Warde John husbandman 594337 594337 Warde, John, of Asshyll, husbandman 2
5410541 2478097 2478097 defendant Smyth Robert yeoman 594337 594337 Smyth, Robert, of Asshyll, yeoman 0
5421118 2481243 2481243 defendant Smyth Robert husbandman 594337 594337 Smyth, Robert, of Asshyll, husbandman 7
5431579 2484399 2484399 plaintiff Koo Richard yeoman 594337 594337 Koo, Richard, of Asshyll, yeoman 0
5440334 2487006 2487006 defendant Smyth Robert husbandman 594337 594337 Smyth, Robert, of Asshyll, husbandman 5
5440346 2487007 2487007 defendant Smyth Robert husbandman 594337 594337 Smyth, Robert, of Asshyll, husbandman 5
5447967 2489275 2489275 plaintiff Koo Richard yeoman 594337 594337 Koo, Richard, of Asshyll, yeoman 0
5453605 2490969 2490969 defendant Elyot Thomas husbandman 594337 594337 Elyot, Thomas, of Asshyll, husbandman 4
5460356 2493036 2493036 plaintiff Koo Richard yeoman 594337 594337 Koo, Richard, of Asshyll, yeoman 0
5471957 2496571 2496571 plaintiff Koo Richard yeoman 594337 594337 Koo, Richard, of Asshyll, yeoman 0
5471960 2496572 2496572 plaintiff Koo Richard yeoman 594337 594337 Koo, Richard, of Asshyll, yeoman 0
5483374 2499974 2499974 plaintiff Koo Richard yeoman 594337 594337 Koo, Richard, of Asshyll, yeoman 0
5483378 2499974 2499974 defendant Elyot Thomas husbandman 594337 594337 Elyot, Thomas, of Asshyll, husbandman 3
5483776 2500093 2500093 defendant Petyt Thomas yeoman 594337 594337 Petyt, Thomas, of Asshyll, yeoman 0
5507683 2507306 2507306 defendant Thaxster John husbandman 594337 594337 Thaxster, John, of Asshyll, husbandman 1
5512269 2508698 2508698 defendant Shynkewyn Richard yeoman 594337 594337 Shynkewyn, Richard, of Asshyll, yeoman 1
5588084 2531285 2531285 defendant Saunders John husbandman 594337 594337 Saunders, John, of Asshyll, husbandman 0
5597145 2534015 2534015 plaintiff Coo Cecilia (legal representative) 594337 594337 Coo, Cecilia, of Asshyll, widow, executor of 0
5597149 2534016 2534016 plaintiff Coo Cecilia (legal representative) 594337 594337 Coo, Cecilia, of Asshyll, widow, executor of 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);