names

34 rows where place_id = 796476

✎ 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
4662610 2249773 2249773 defendant Harlewyn John   796476 796476 Harlewyn, John, of Stonham Aspale, wright 4
4751245 2280840 2280840 defendant Canon John yeoman 796476 796476 Canon, John, of Stonham Aspale, yeoman 1
4835510 2307099 2307099 defendant Campe William yeoman 796476 796476 Campe, William, of Stonham Aspale, yeoman 1
4871874 2318177 2318177 defendant Campe William yeoman 796476 796476 Campe, William, of Stonham Aspale, yeoman 0
4893697 2324725 2324725 defendant Campe William husbandman 796476 796476 Campe, William, of Stonham Aspale, husbandman 0
4893698 2324725 2324725 defendant Morgon John husbandman 796476 796476 Morgon, John, of Stonham Aspale, husbandman 1
4985679 2352630 2352630 defendant Caump William husbandman 796476 796476 Caump, William, of Stonham Aspale, husbandman 3
5018450 2362279 2362279 defendant Campe William husbandman 796476 796476 Campe, William, of Stonham Aspale, husbandman 0
5019847 2362684 2362684 defendant Campe William yeoman 796476 796476 Campe, William, of Stonham Aspale, yeoman 2
5025336 2364303 2364303 defendant Campe William husbandman 796476 796476 Campe, William, of Stonham Aspale, husbandman 1
5041800 2369148 2369148 defendant Campe William husbandman 796476 796476 Campe, William, of Stonham Aspale, husbandman 0
5045150 2370178 2370178 defendant Campe William husbandman 796476 796476 Campe, William, of Stonham Aspale, husbandman 1
5068549 2377084 2377084 defendant Pecher Thomas husbandman 796476 796476 Pecher, Thomas, of Stonham Aspale, husbandman 5
5070625 2377712 2377712 defendant Caump Robert yeoman 796476 796476 Caump, Robert, of Stonham Aspale, yeoman 0
5070636 2377716 2377716 defendant Caump Robert yeoman 796476 796476 Caump, Robert, of Stonham Aspale, yeoman 0
5084405 2381846 2381846 defendant Morgon John husbandman 796476 796476 Morgon, John, of Stonham Aspale, husbandman 0
5084406 2381846 2381846 defendant Morgon Reginald yeoman 796476 796476 Morgon, Reginald, of Stonham Aspale, yeoman 1
5093060 2384357 2384357 defendant Ca- William husbandman 796476 796476 Ca-, William, of Stonham Aspale, husbandman 6
5144242 2399468 2399468 defendant Pechyr Thomas husbandman 796476 796476 Pechyr, Thomas, of Stonham Aspale, husbandman 2
5165146 2405552 2405552 defendant Pethyr Thomas husbandman 796476 796476 Pethyr, Thomas, of Stonham Aspale, husbandman 2
5235050 2425832 2425832 defendant Caump William husbandman 796476 796476 Caump, William, of Stonham Aspale, husbandman 0
5270836 2436566 2436566 defendant Brette John baker 796476 796476 Brette, John, of Stonham Aspale, baker 0
5387435 2471476 2471476 defendant Grey Thomas husbandman 796476 796476 Grey, Thomas, of Stonham Aspale, husbandman 0
5418088 2480336 2480336 defendant Jenour William yeoman 796476 796476 Jenour, William, of Stonham Aspale, yeoman 0
5418090 2480336 2480336 defendant Teryngton Thomas painter 796476 796476 Teryngton, Thomas, of Stonham Aspale, painter 2
5427923 2483304 2483304 defendant Grey Thomas husbandman 796476 796476 Grey, Thomas, of Stonham Aspale, husbandman 0
5435822 2485657 2485657 defendant Jenour William yeoman 796476 796476 Jenour, William, of Stonham Aspale, yeoman 0
5435824 2485657 2485657 defendant Teryngton William painter 796476 796476 Teryngton, William, of Stonham Aspale, painter 2
5435827 2485658 2485658 defendant Jenour William yeoman 796476 796476 Jenour, William, of Stonham Aspale, yeoman 0
5435829 2485658 2485658 defendant Teryngton William painter 796476 796476 Teryngton, William, of Stonham Aspale, painter 2
5443071 2487837 2487837 defendant Jenour William   796476 796476 Jenour, William, of Stonham Aspale 0
5445490 2488548 2488548 defendant Grey Thomas husbandman 796476 796476 Grey, Thomas, of Stonham Aspale, husbandman 0
5458273 2492374 2492374 defendant Grey Thomas husbandman 796476 796476 Grey, Thomas, of Stonham Aspale, husbandman 0
5465954 2494744 2494744 defendant Grey Thomas husbandman 796476 796476 Grey, Thomas, of Stonham Aspale, husbandman 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);