names

52 rows where place_id = 592917

✎ 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
3609387 1870596 1870596 defendant Mykrygge Thomas tucker 592917 592917 Mykrygge, Thomas, of Colompton, Devon, tucker 0
3671250 1916983 1916983 defendant Davy John merchant 592917 592917 Davy, John, of Colompton, Devon, merchant 0
3914277 1995119 1995119 defendant More Richard gent 592917 592917 More, Richard, of Colompton, Devon, gent 1
3915218 1995450 1995450 defendant More Richard gent 592917 592917 More, Richard, of Colompton, Devon, gent 0
3956778 2009438 2009438 plaintiff Paige William   592917 592917 Paige, William, of Colompton, Devon 0
3976342 2016300 2016300 plaintiff Keilway Simon merchant 592917 592917 Keilway, Simon, of Colompton, Devon, merchant 0
3991392 2021675 2021675 defendant Skynner Henry yeoman 592917 592917 Skynner, Henry, of Colompton, Devon, yeoman 0
4006125 2026963 2026963 defendant Dawe John yeoman 592917 592917 Dawe, John, of Colompton, Devon, yeoman 0
4023384 2033074 2033074 defendant Hardyng John merchant 592917 592917 Hardyng, John, of Colompton, Devon, merchant 0
4042148 2039678 2039678 plaintiff Page William (legal representative) 592917 592917 Page, William, of Colompton, Devon, merchant, executors of 0
4042152 2039679 2039679 plaintiff Page William (legal representative) 592917 592917 Page, William, of Colompton, Devon, merchant, executors of 0
4052216 2043214 2043214 defendant Moore John   592917 592917 Moore, John, of Colompton, Devon, knight 0
4089609 2056575 2056575 defendant Bale Walter tucker 592917 592917 Bale, Walter, of Colompton, Devon, tucker 0
4114720 2065553 2065553 defendant Courtney Edward gent 592917 592917 Courtney, Edward, of Colompton, Devon, gent 2
4114998 2065653 2065653 defendant Dawe John yeoman 592917 592917 Dawe, John, of Colompton, Devon, yeoman 0
4115004 2065655 2065655 defendant Dawe John yeoman 592917 592917 Dawe, John, of Colompton, Devon, yeoman 0
4116395 2066152 2066152 defendant Tompson Thomas gent 592917 592917 Tompson, Thomas, of Colompton, Devon, gent 0
4123049 2068539 2068539 defendant Tye Edward gent 592917 592917 Tye, Edward, of Colompton, Devon, gent 1
4127303 2070059 2070059 defendant Drewe John husbandman 592917 592917 Drewe, John, of Colompton, Devon, husbandman 2
4127339 2070068 2070068 defendant Woodley William gent 592917 592917 Woodley, William, of Colompton, Devon, gent 0
4139713 2074566 2074566 defendant Pytt John tucker 592917 592917 Pytt, John, of Colompton, Devon, tucker 0
4146537 2076939 2076939 defendant Clatter Simon clothier 592917 592917 Clatter, Simon, of Colompton, Devon, clothier 2
4156733 2080433 2080433 defendant Balle William gent 592917 592917 Balle, William, of Colompton, Devon, gent 0
4156736 2080434 2080434 defendant Balle William gent 592917 592917 Balle, William, of Colompton, Devon, gent 0
4180746 2088746 2088746 defendant Dowryshe Walter esq 592917 592917 Dowryshe, Walter, of Colompton, Devon, esq 0
4192112 2092803 2092803 defendant Bale Walter tucker 592917 592917 Bale, Walter, of Colompton, Devon, tucker 0
4192122 2092808 2092808 defendant Pytt John tucker 592917 592917 Pytt, John, of Colompton, Devon, tucker 0
4205330 2097414 2097414 defendant Bale Walter fuller 592917 592917 Bale, Walter, of Colompton, Devon, fuller 0
4205345 2097419 2097419 defendant Grene Thomas yeoman 592917 592917 Grene, Thomas, of Colompton, Devon, yeoman 0
4213971 2100409 2100409 defendant Skynner James merchant 592917 592917 Skynner, James, of Colompton, Devon, merchant 0
4215862 2101046 2101046 defendant Sanforde Anthony gent 592917 592917 Sanforde, Anthony, of Colompton, Devon, gent 0
4222480 2103355 2103355 defendant Skynner James merchant 592917 592917 Skynner, James, of Colompton, Devon, merchant 0
4245276 2111404 2111404 defendant Barton John yeoman 592917 592917 Barton, John, of Colompton, Devon, yeoman 0
4288409 2125903 2125903 defendant Hayes John gent 592917 592917 Hayes, John, of Colompton, Devon, gent 0
4292198 2127281 2127281 defendant Skynner Joan widow 592917 592917 Skynner, Joan, of Colompton, Devon, widow 0
4312228 2134413 2134413 defendant Balle William yeoman 592917 592917 Balle, William, of Colompton, Devon, yeoman 1
4330408 2140469 2140469 defendant Skott Thomas yeoman 592917 592917 Skott, Thomas, of Colompton, Devon, yeoman, servant to Humphrey More, of Collomton, yeoman 0
4333240 2141402 2141402 defendant Sampford or Sanforde Bartholomew gent 592917 592917 Sampford or Sanforde, Bartholomew, of Colompton, Devon, gent 2
4333643 2141534 2141534 defendant Lovejoye Robert yeoman 592917 592917 Lovejoye, Robert, of Colompton, Devon, yeoman 0
4337624 2142908 2142908 defendant Hayes John gent 592917 592917 Hayes, John, of Colompton, Devon, gent 0
4356120 2149363 2149363 defendant Beere Hugh chapman 592917 592917 Beere, Hugh, of Colompton, Devon, chapman 2
4371079 2154715 2154715 defendant Hayes John gent 592917 592917 Hayes, John, of Colompton, Devon, gent 0
4372525 2155244 2155244 defendant Skynner Richard gent 592917 592917 Skynner, Richard, of Colompton, Devon, gent 0
4388332 2160729 2160729 defendant Stevens John dyer 592917 592917 Stevens, John, of Colompton, Devon, dyer 0
4398150 2163961 2163961 defendant Langdon Roger weaver 592917 592917 Langdon, Roger, of Colompton, Devon, weaver 2
4964918 2346422 2346422 defendant Sutter John dyer 592917 592917 Sutter, John, of Colompton, Devon, dyer 0
5042296 2369300 2369300 defendant Ford Robert smith 592917 592917 Ford, Robert, of Colompton, Devon, smith 3
5313319 2449021 2449021 defendant Waget William chapman 592917 592917 Waget, William, of Colompton, Devon, chapman 2
5516502 2509988 2509988 defendant Roper Robert yeoman 592917 592917 Roper, Robert, of Colompton, Devon, yeoman 0
5550108 2520066 2520066 defendant Keynes John gent 592917 592917 Keynes, John, of Colompton, Devon, gent 2
5555078 2521491 2521491 defendant Chace John dyer 592917 592917 Chace, John, of Colompton, Devon, dyer 1
5559360 2522704 2522704 defendant Chase John dyer 592917 592917 Chase, John, of Colompton, Devon, dyer 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);