names

34 rows where place_id = 606330

✎ 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
3604265 1868997 1868997 plaintiff Gervase Thomas (legal representative) 606330 606330 Gervase, Thomas, of Pykwell, husbandman, executors of 0
3664818 1914942 1914942 defendant Marston Thomas yeoman 606330 606330 Marston, Thomas, of Pykwell, yeoman 0
3681110 1920174 1920174 defendant Marston Thomas husbandman 606330 606330 Marston, Thomas, of Pykwell, husbandman 0
3721211 1932935 1932935 defendant Flower John gent 606330 606330 Flower, John, of Pykwell, gent 0
3721214 1932936 1932936 defendant Flower John gent 606330 606330 Flower, John, of Pykwell, gent 0
3754593 1943395 1943395 defendant Dansey Thomas husbandman 606330 606330 Dansey, Thomas, of Pykwell, husbandman 0
3756073 1943855 1943855 defendant Hedge William yeoman 606330 606330 Hedge, William, of Pykwell, yeoman 0
3781766 1952042 1952042 plaintiff Hege William   606330 606330 Hege, William, of Pykwell 0
3781970 1952108 1952108 plaintiff Heye William   606330 606330 Heye, William, of Pykwell 0
3796842 1956892 1956892 defendant Hegge William husbandman 606330 606330 Hegge, William, of Pykwell, husbandman 0
4482604 2195262 2195262 defendant Taillour Richard   606330 606330 Taillour, Richard, of Pykwell 0
4635914 2242066 2242066 defendant Smyth John chaplain 606330 606330 Smyth, John, of Pykwell, chaplain 0
4635915 2242066 2242066 defendant Botiller John   606330 606330 Botiller, John, of Pykwell 1
4635916 2242066 2242066 defendant Chapman Richard   606330 606330 Chapman, Richard, of Pykwell 2
4926877 2334836 2334836 plaintiff Reynold John   606330 606330 Reynold, John, of Pykwell 0
5383411 2470335 2470335 defendant Bosse Richard husbandman 606330 606330 Bosse, Richard, of Pykwell, husbandman 0
5463612 2494032 2494032 defendant Man William husbandman 606330 606330 Man, William, of Pykwell, husbandman 0
5463613 2494032 2494032 defendant Payntour George husbandman 606330 606330 Payntour, George, of Pykwell, husbandman 1
5463614 2494032 2494032 defendant Peale John husbandman 606330 606330 Peale, John, of Pykwell, husbandman 2
5463905 2494122 2494122 defendant Cristian William husbandman 606330 606330 Cristian, William, of Pykwell, husbandman 1
5475186 2497563 2497563 defendant Man William husbandman 606330 606330 Man, William, of Pykwell, husbandman 0
5475187 2497563 2497563 defendant Payntour George husbandman 606330 606330 Payntour, George, of Pykwell, husbandman 1
5475188 2497563 2497563 defendant Peale John husbandman 606330 606330 Peale, John, of Pykwell, husbandman 2
5501147 2505295 2505295 defendant Crystyan William husbandman 606330 606330 Crystyan, William, of Pykwell, husbandman 0
5521337 2511489 2511489 defendant Hegge William tailor 606330 606330 Hegge, William, of Pykwell, tailor 0
5521338 2511489 2511489 defendant Mower Joan spinster 606330 606330 Mower, Joan, of Pykwell, spinster 1
5521342 2511491 2511491 defendant Taverner Robert   606330 606330 Taverner, Robert, of Pykwell, shepherd 0
5536835 2516008 2516008 defendant Jays Agnes spinster 606330 606330 Jays, Agnes, of Pykwell, spinster 0
5536836 2516008 2516008 defendant Hill Margaret spinster 606330 606330 Hill, Margaret, of Pykwell, spinster 1
5536838 2516009 2516009 defendant Joys Agnes spinster 606330 606330 Joys, Agnes, of Pykwell, spinster 0
5536839 2516009 2516009 defendant Hill Margaret spinster 606330 606330 Hill, Margaret, of Pykwell, spinster 1
5536843 2516011 2516011 defendant Whetley Joan spinster 606330 606330 Whetley, Joan, of Pykwell, spinster 0
5599368 2534687 2534687 defendant Clement William husbandman 606330 606330 Clement, William, of Pykwell, husbandman 0
5629223 2553114 2553114 defendant Smyth John clerk 606330 606330 Smyth, John, of Pykwell, clerk 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);