names

41 rows where place_id = 593657

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612808 1871656 1871656 plaintiff Adamson Robert (legal representative) 593657 593657 Adamson, Robert, of Blithe, executor of 0
3612809 1871656 1871656 plaintiff Adamson Richard   593657 593657 Adamson, Richard, of Blithe 1
3625933 1902967 1902967 defendant Thomson Thomas laborer 593657 593657 Thomson Thomas, of Blithe, laborer 0
3628023 1903617 1903617 defendant Holbek Bartholomew   593657 593657 Holbek, Bartholomew, of Blithe, wright 2
3654023 1911520 1911520 defendant Peke John yeoman 593657 593657 Peke, John, of Blithe, yeoman 1
4322892 2138072 2138072 defendant Rogers George yeoman 593657 593657 Rogers, George, of Blithe, yeoman 1
4322893 2138072 2138072 defendant Pye Thomas yeoman 593657 593657 Pye, Thomas, of Blithe, yeoman 2
4415510 2169737 2169737 defendant Mareschal Richard   593657 593657 Mareschal, Richard, of Blithe 0
4426710 2173167 2173167 plaintiff Person Alice daughter of William 593657 593657 Person, Alice, of Blithe,,daughter of William 0
4426713 2173168 2173168 plaintiff Person Alice daughter of William 593657 593657 Person, Alice, of Blithe,,daughter of William 0
4606338 2233097 2233097 defendant Watson Thomas   593657 593657 Watson, Thomas, of Blithe 3
4667141 2255458 2255458 defendant Belhous Thomas yeoman 593657 593657 Belhous, Thomas, of Blithe, yeoman 1
4667142 2255458 2255458 defendant Bagley Thomas draper 593657 593657 Bagley, Thomas, of Blithe, draper 2
4667143 2255458 2255458 defendant Taillour Edmund tailor 593657 593657 Taillour, Edmund, of Blithe, tailor 3
4667144 2255458 2255458 defendant del Chambre John yeoman 593657 593657 del Chambre, John, of Blithe, yeoman 4
4698227 2264929 2264929 defendant Pog John   593657 593657 Pog, John, of Blithe, wright 2
4713974 2269699 2269699 defendant Malyn Thomas hosteller 593657 593657 Malyn, Thomas, of Blithe, hosteller 0
4793246 2293982 2293982 defendant Knolles William chapman 593657 593657 Knolles, William, of Blithe, chapman 1
4916803 2331759 2331759 defendant Snowe John husbandman 593657 593657 Snowe, John, of Blithe, husbandman 11
4920044 2332781 2332781 defendant Tapster Alice widow 593657 593657 Tapster, Alice, of Blithe, widow 0
4932124 2336442 2336442 defendant Kendele William widow 593657 593657 Kendele, William, of Blithe, husbandman. Wellesby, Joan, of Bekyngham, widow 3
4938685 2338483 2338483 defendant Hudson Richard yeoman 593657 593657 Hudson, Richard, of Blithe, yeoman 0
4939670 2338794 2338794 defendant Skynner Richard laborer 593657 593657 Skynner, Richard, of Blithe, laborer 0
4939672 2338794 2338794 defendant Taillour John draper 593657 593657 together with Taillour, John, of Blithe, draper 2
4939673 2338794 2338794 defendant Kerver William carver 593657 593657 Kerver, William, of Blithe, carver 3
4947670 2341259 2341259 defendant Donse or Douse Roger cordwainer 593657 593657 Donse or Douse, Roger, of Blithe, cordwainer 4
4947682 2341262 2341262 defendant Fissher William butcher 593657 593657 Fissher, William, of Blithe, butcher 0
5063096 2375499 2375499 defendant Baron William ostler or draper 593657 593657 Baron, William, of Blithe, ostler or draper 4
5087367 2382687 2382687 defendant Tukker or Tulker Henry   593657 593657 Tukker or Tulker, Henry, of Blithe, wright 0
5087369 2382687 2382687 defendant Candeler William butcher 593657 593657 Candeler, William, of Blithe, butcher 2
5246484 2429134 2429134 defendant Gabbe John yeoman 593657 593657 Gabbe, John, of Blithe, yeoman 5
5248778 2429762 2429762 defendant Sparge John yeoman 593657 593657 Sparge, John, of Blithe, yeoman 4
5265551 2434986 2434986 defendant Lauson Thomas   593657 593657 Lauson, Thomas, of Blithe, cartwright 0
5265552 2434986 2434986 defendant Chaundeler William butcher 593657 593657 Chaundeler, William, of Blithe, butcher 1
5265553 2434986 2434986 defendant Talour John tailor 593657 593657 Talour, John, of Blithe, tailor 2
5265554 2434986 2434986 defendant Sparge John yeoman 593657 593657 Sparge, John, of Blithe, yeoman 3
5265555 2434986 2434986 defendant Sparge Robert shoemaker 593657 593657 Sparge, Robert, of Blithe, shoemaker 4
5418706 2480519 2480519 defendant Jauson Edmund yeoman 593657 593657 Jauson, Edmund, of Blithe, yeoman 0
5418707 2480519 2480519 defendant Jebbe John tanner 593657 593657 Jebbe, John, of Blithe, tanner 1
5418708 2480519 2480519 defendant Wodur John butcher 593657 593657 Wodur, John, of Blithe, butcher 2
5418709 2480519 2480519 defendant Kirkeby John yeoman 593657 593657 Kirkeby, John, of Blithe, yeoman 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);