names

21 rows where place_id = 595459

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3620554 1874004 1874004 defendant Stowey Thomas husbandman 595459 595459 Stowey, Thomas, of Cutcombe, husbandman 0
3620555 1874004 1874004 defendant Underwode William husbandman 595459 595459 Underwode, William, of Cutcombe, husbandman 1
3723959 1933775 1933775 defendant Popham William husbandman 595459 595459 Popham, William, of Cutcombe, husbandman 0
3732583 1936420 1936420 defendant Hugh alias Davy John miller 595459 595459 Hugh alias Davy, John, of Cutcombe, miller 0
3760177 1945182 1945182 defendant Hugh alias Davy John miller 595459 595459 Hugh alias Davy, John, of Cutcombe, miller 0
3778243 1950904 1950904 defendant Hugh alias Davy John miller 595459 595459 Hugh alias Davy, John, of Cutcombe, miller 0
3894536 1988382 1988382 defendant Rudler Walter husbandman 595459 595459 Rudler, Walter, of Cutcombe, husbandman 0
4206249 2097733 2097733 defendant Escott Christopher yeoman 595459 595459 Escott, Christopher, of Cutcombe, yeoman 0
4299875 2130045 2130045 defendant Lewes John clerk 595459 595459 Lewes, John, of Cutcombe, clerk 0
4378592 2157416 2157416 defendant Widlake or Witlake alias Hawkwell John husbandman 595459 595459 Widlake or Witlake alias Hawkwell, John, of Cutcombe, husbandman 1
4379643 2157813 2157813 defendant Hughe Henry yeoman 595459 595459 Hughe, Henry, of Cutcombe, yeoman 0
4404412 2166042 2166042 defendant Lewes John clerk 595459 595459 Lewes, John, of Cutcombe, clerk 2
4404413 2166042 2166042 defendant Lewes Beatrice spinster 595459 595459 Lewes, Beatrice, of Cutcombe, spinster 3
4408628 2167479 2167479 defendant Nurcombe Robert husbandman 595459 595459 Nurcombe, Robert, of Cutcombe, husbandman 0
5140498 2398325 2398325 defendant Caunte Henry clerk 595459 595459 Caunte, Henry, of Cutcombe, clerk 1
5161638 2404504 2404504 defendant Caunte Henry clerk 595459 595459 Caunte, Henry, of Cutcombe, clerk 1
5197690 2415065 2415065 defendant Caunte Henry clerk 595459 595459 Caunte, Henry, of Cutcombe, clerk 0
5288528 2441660 2441660 defendant Strotenger William clerk 595459 595459 Strotenger, William, of Cutcombe, clerk 0
5525577 2512590 2512590 defendant Haukewell Robert husbandman 595459 595459 Haukewell, Robert, of Cutcombe, husbandman 0
5527464 2513172 2513172 defendant Stowey Thomas husbandman 595459 595459 Stowey, Thomas, of Cutcombe, husbandman 0
5535225 2515545 2515545 defendant Popham William gent 595459 595459 Popham, William, of Cutcombe, gent 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);