names

43 rows where place_id = 588335

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594144 1865811 1865811 defendant Savage John clerk 588335 588335 Savage, John, of Fornset, clerk 0
3597535 1866851 1866851 defendant Baxster Richard (legal representative) 588335 588335 Baxster, Richard, of Fornset, husbandman, executrix of 0
3597536 1866851 1866851 defendant Baxster Isabel widow 588335 588335 Baxster, Isabel, of Fornset, widow 1
3615915 1872618 1872618 defendant Davy Robert husbandman 588335 588335 Davy, Robert, of Fornset, husbandman 0
3787767 1953965 1953965 defendant Bryghtyese Robert husbandman 588335 588335 Bryghtyese, Robert, of Fornset, husbandman 1
4869341 2317378 2317378 defendant Dufy or Dusy Robert husbandman 588335 588335 Dufy or Dusy, Robert, of Fornset, husbandman 0
4869342 2317378 2317378 defendant Sergeant Robert husbandman 588335 588335 Sergeant, Robert, of Fornset, husbandman 1
4954603 2343333 2343333 defendant Ryngere John yeoman 588335 588335 Ryngere, John, of Fornset, yeoman 5
5023656 2363826 2363826 defendant Reede Robert tailor 588335 588335 Reede, Robert, of Fornset, tailor 2
5023661 2363827 2363827 defendant Reede Robert tailor 588335 588335 Reede, Robert, of Fornset, tailor 2
5025625 2364403 2364403 defendant Wronge John yeoman 588335 588335 Wronge, John, of Fornset, yeoman 0
5036575 2367561 2367561 defendant Wronge John yeoman 588335 588335 Wronge, John, of Fornset, yeoman 0
5044427 2369962 2369962 defendant Verdon William yeoman 588335 588335 Verdon, William, of Fornset, yeoman 1
5062226 2375261 2375261 defendant Reed Robert tailor 588335 588335 Reed, Robert, of Fornset, tailor 2
5115762 2391039 2391039 defendant Verdon William husbandman 588335 588335 Verdon, William, of Fornset, husbandman 1
5115763 2391039 2391039 defendant Rede Robert husbandman 588335 588335 Rede, Robert, of Fornset, husbandman 2
5115770 2391039 2391039 defendant Buk Robert husbandman 588335 588335 Buk, Robert, of Fornset, husbandman 9
5115771 2391039 2391039 defendant Buntyng John husbandman 588335 588335 Buntyng, John, of Fornset, husbandman 10
5124748 2393714 2393714 defendant Buntyng John husbandman 588335 588335 Buntyng, John, of Fornset, husbandman 2
5136999 2397337 2397337 defendant Kyrton John husbandman 588335 588335 Kyrton, John, of Fornset, husbandman 0
5137684 2397535 2397535 defendant Verdon William yeoman 588335 588335 Verdon, William, of Fornset, yeoman 0
5143337 2399190 2399190 defendant Buntyng John husbandman 588335 588335 Buntyng, John, of Fornset, husbandman 2
5144695 2399604 2399604 defendant Rynger John, sen yeoman 588335 588335 Rynger, John, sen, of Fornset, yeoman 1
5158378 2403572 2403572 defendant Verdon William yeoman 588335 588335 Verdon, William, of fornset, yeoman 0
5201792 2416291 2416291 defendant Buntyng John husbandman 588335 588335 Buntyng, John, of Fornset, husbandman 1
5233002 2425234 2425234 defendant Hotte John yeoman 588335 588335 Hotte, John, of Fornset, yeoman 2
5299888 2444933 2444933 defendant Burgeys Gregory husbandman 588335 588335 Burgeys, Gregory, of Fornset, husbandman 4
5325254 2452641 2452641 defendant Hykkys Robert   588335 588335 Hykkys, Robert, of Fornset, worsted weaver 4
5352869 2460984 2460984 defendant Nellehalle Hugh chaplain 588335 588335 Nellehalle, Hugh, of Fornset, chaplain 0
5369877 2466166 2466166 defendant Boteld Robert butcher 588335 588335 Boteld, Robert, of Fornset, butcher 1
5417383 2480118 2480118 defendant Sergeaunt John yeoman 588335 588335 Sergeaunt, John, of Fornset, yeoman 0
5428517 2483458 2483458 defendant Hykkys Robert husbandman 588335 588335 Hykkys, Robert, of Fornset, husbandman 1
5434723 2485320 2485320 defendant Sergeaunt John yeoman 588335 588335 Sergeaunt, John, of Fornset, yeoman 0
5434725 2485321 2485321 defendant Sergeaunt John yeoman 588335 588335 Sergeaunt, John, of Fornset, yeoman 0
5450029 2489896 2489896 defendant Sergeaunt John yeoman 588335 588335 Sergeaunt, John, of Fornset, yeoman 0
5477059 2498145 2498145 defendant Rede John yeoman 588335 588335 Rede, John, of Fornset, yeoman 0
5477060 2498145 2498145 defendant Davy Robert husbandman 588335 588335 Davy, Robert, of Fornset, husbandman 1
5477061 2498145 2498145 defendant Pyllet William husbandman 588335 588335 Pyllet, William, of Fornset, husbandman 2
5488630 2501482 2501482 defendant Rede John yeoman 588335 588335 Rede, John, of Fornset, yeoman 2
5488631 2501482 2501482 defendant Davy Robert husbandman 588335 588335 Davy, Robert, of Fornset, husbandman 3
5488632 2501482 2501482 defendant Pyllet William husbandman 588335 588335 Pyllet, William, of Fornset, husbandman 4
5554643 2521386 2521386 defendant Baxster Thomas yeoman 588335 588335 Baxster, Thomas, of Fornset, yeoman 0
5582114 2529475 2529475 defendant Skarlett William chaplain 588335 588335 Skarlett, William, of Fornset, chaplain 3

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);