names

30 rows where place_id = 599362

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3636458 1906194 1906194 defendant Sewet John laborer 599362 599362 Sewet, John, of Fokyngton, laborer 1
3667885 1915896 1915896 defendant Bright William tanner 599362 599362 Bright, William, of Fokyngton, tanner 0
3735734 1937414 1937414 defendant A Word John husbandman 599362 599362 A Word, John, of Fokyngton, husbandman 0
3861585 1977335 1977335 defendant Pykenotte John butcher 599362 599362 Pykenotte, John, of Fokyngton, butcher 0
3895865 1988826 1988826 defendant Harvy William husbandman 599362 599362 Harvy, William, of Fokyngton, husbandman 0
3960715 2010848 2010848 defendant Pupp Anthony husbandman 599362 599362 Pupp, Anthony, of Fokyngton, husbandman 0
3961613 2011162 2011162 defendant Puppe Anthony husbandman 599362 599362 Puppe, Anthony, of Fokyngton, husbandman 0
4072430 2050442 2050442 defendant Doredge John yeoman 599362 599362 Doredge, John, of Fokyngton, yeoman 0
4095227 2058615 2058615 defendant Alye John laborer 599362 599362 Alye, John, of Fokyngton, laborer 0
4108650 2063348 2063348 defendant Howell Robert yeoman 599362 599362 Howell, Robert, of Fokyngton, yeoman 0
4122207 2068247 2068247 defendant Store alias Stoworth Ralph clerk 599362 599362 Store alias Stoworth, Ralph, of Fokyngton, clerk 0
4122208 2068247 2068247 defendant Tayler Mathew husbandman 599362 599362 Tayler, Mathew, of Fokyngton, husbandman 1
4122209 2068247 2068247 defendant Bysshopp John husbandman 599362 599362 Bysshopp, John, of Fokyngton, husbandman 2
4130062 2071058 2071058 defendant Spryngatt William carpenter 599362 599362 Spryngatt, William, of Fokyngton, carpenter 0
4135608 2073059 2073059 defendant Howell Robert yeoman 599362 599362 Howell, Robert, of Fokyngton, yeoman 1
4173990 2086359 2086359 defendant Rowe William husbandman 599362 599362 Rowe, William, of Fokyngton, husbandman 1
4226072 2104590 2104590 defendant Hemsley James tanner 599362 599362 Hemsley, James, of Fokyngton, tanner 0
4227241 2105007 2105007 defendant Downton or Dunton William husbandman 599362 599362 Downton or Dunton, William, of Fokyngton, husbandman 0
4227781 2105198 2105198 defendant Hemsley James husbandman 599362 599362 Hemsley, James, of Fokyngton, husbandman 1
4227838 2105218 2105218 defendant Hemsley James tanner 599362 599362 Hemsley, James, of Fokyngton, tanner 1
4231657 2106574 2106574 defendant Stoward Randolph clerk 599362 599362 Stoward, Randolph, of Fokyngton, clerk 0
4267821 2118872 2118872 defendant Downton or Dunton William husbandman 599362 599362 Downton or Dunton, William, of Fokyngton, husbandman 0
4318745 2136667 2136667 defendant Hemsley James tanner 599362 599362 Hemsley, James, of Fokyngton, or of Gevington, tanner 0
4321172 2137499 2137499 defendant Hemsley James tanner 599362 599362 Hemsley, James, of Fokyngton, tanner 1
4524041 2207853 2207853 plaintiff Heth John   599362 599362 Heth, John, of Fokyngton, parson 0
5079297 2380303 2380303 defendant Ayghtacre John laborer 599362 599362 Ayghtacre, John, of Fokyngton, laborer 0
5132585 2396026 2396026 defendant Wylmot Walter laborer 599362 599362 Wylmot, Walter, of Fokyngton, laborer 0
5538670 2516577 2516577 defendant Perys James tanner 599362 599362 Perys, James, of Fokyngton, tanner 0
5538671 2516577 2516577 defendant Body John husbandman 599362 599362 Body, John, of Fokyngton, husbandman 1
5624053 2551469 2551469 defendant atte Broke Thomas husbandman 599362 599362 atte Broke, Thomas, of Fokyngton, husbandman 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);