names

37 rows where place_id = 654513

✎ 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
3932682 2001228 2001228 defendant Colte John husbandman 654513 654513 Colte, John, of Little Munden, husbandman 0
4279108 2122623 2122623 defendant Ireland William maltman 654513 654513 Ireland, William, of Little Munden, maltman 1
4642509 2243934 2243934 defendant Telle John   654513 654513 Telle, John, of Little Munden 1
4649712 2245942 2245942 defendant Chapman John   654513 654513 Chapman, John, of Little Munden 1
4733941 2275800 2275800 defendant White William husbandman 654513 654513 White, William, of Little Munden, husbandman 0
4740058 2277607 2277607 defendant Maykyn Philip yeoman 654513 654513 Maykyn, Philip, of Little Munden, yeoman 3
4828750 2305033 2305033 defendant Prentyse Richard husbandman 654513 654513 Prentyse, Richard, of Little Munden, husbandman 0
4828760 2305036 2305036 defendant Averell John yeoman 654513 654513 Averell, John, of Little Munden, yeoman 0
4828761 2305036 2305036 defendant Prentise Richard husbandman 654513 654513 Prentise, Richard, of Little Munden, husbandman 1
4850556 2311635 2311635 defendant atte Mille John husbandman 654513 654513 atte Mille, John, of Little Munden, husbandman 2
4917551 2332005 2332005 defendant Brokholes John   654513 654513 Brokholes, John, of Little Munden, shepherd 0
5133359 2396248 2396248 defendant Gayler William maltman 654513 654513 Gayler, William, of Little Munden, maltman 0
5137492 2397477 2397477 defendant Gayler William   654513 654513 Gayler, William, of Little Munden, malt man 3
5159503 2403895 2403895 defendant Chapman John potter 654513 654513 Chapman, John, of Little Munden, potter 0
5160550 2404176 2404176 defendant Gayler William maltman 654513 654513 Gayler, William, of Little Munden, maltman 1
5185432 2411486 2411486 defendant Bastard William gent 654513 654513 Bastard, William, of Little Munden, gent 0
5187694 2412118 2412118 defendant Plumme Thomas husbandman 654513 654513 Plumme, Thomas, of Little Munden, husbandman 2
5187696 2412118 2412118 defendant Burnard Robert laborer 654513 654513 Burnard, Robert, of Little Munden, laborer 4
5195517 2414439 2414439 defendant Gayler William husbandman 654513 654513 Gayler, William, of of Little Munden, husbandman 2
5195518 2414439 2414439 defendant Potter Helen widow 654513 654513 Potter, Helen, of Little Munden, widow 3
5195519 2414439 2414439 defendant Plumme Thomas husbandman 654513 654513 Plumme, Thomas, of Little Munden, husbandman 4
5205674 2417403 2417403 defendant Plumme Thomas husbandman 654513 654513 Plumme, Thomas, of Little Munden, husbandman 2
5205676 2417403 2417403 defendant Burnard Robert laborer 654513 654513 Burnard, Robert, of Little Munden, laborer 4
5274310 2437568 2437568 defendant Plumme Thomas tilemaker 654513 654513 Plumme, Thomas, of Little Munden, tilemaker 0
5274311 2437568 2437568 defendant Norys Eustace husbandman 654513 654513 Norys, Eustace, of Little Munden, husbandman 1
5274312 2437568 2437568 defendant Plumme Philip husbandman 654513 654513 Plumme, Philip, of LIttle Munden, husbandman 2
5306802 2447027 2447027 defendant Colt John maltman 654513 654513 Colt, John, of Little Munden, maltman 0
5388604 2471795 2471795 defendant Andrewe William maltman 654513 654513 Andrewe, William, of Little Munden, maltman 1
5401230 2475411 2475411 defendant Andrewe William   654513 654513 Andrewe, William, of Little Munden, malt man 1
5401370 2475457 2475457 defendant Andrews William maltman 654513 654513 Andrews, William, of Little Munden, maltman 1
5414243 2479193 2479193 defendant Andrewe William maltman 654513 654513 Andrewe, William, of Little Munden, maltman 1
5419632 2480791 2480791 defendant Colte John maltman 654513 654513 Colte, John, of Little Munden, maltman 0
5429912 2483885 2483885 defendant Andrewe William maltman 654513 654513 Andrewe, William, of Little Munden, maltman 1
5438050 2486314 2486314 defendant Colte John maltman 654513 654513 Colte, John, of Little Munden, maltman 0
5438054 2486315 2486315 defendant Colte John maltman 654513 654513 Colte, John, of Little Munden, maltman 0
5438058 2486316 2486316 defendant Colte John maltman 654513 654513 Colte, John, of Little Munden, maltman 0
5447100 2489022 2489022 defendant Andrewe William maltman 654513 654513 Andrewe, William, of Little Munden, maltman 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);