names

29 rows where place_id = 606263

✎ 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
3595291 1866159 1866159 defendant Cantrell James husbandman 606263 606263 Cantrell, James, of Wynster, husbandman, son of Cantrell, Thomas, of Wynster, husbandman 1
3664639 1914894 1914894 defendant Merten Ralph yeoman 606263 606263 Merten, Ralph, of Wynster, yeoman 0
4158718 2081122 2081122 defendant Parker Edward yeoman 606263 606263 Parker, Edward, of Wynster, yeoman 2
4362460 2151622 2151622 defendant Meynell Robert gent 606263 606263 Meynell, Robert, of Wynster, gent 0
4385492 2159835 2159835 defendant Hurde George miner 606263 606263 Hurde, George, of Wynster, miner 2
4390849 2161554 2161554 defendant Hurde George gent 606263 606263 Hurde, George, of Wynster, gent 0
4390850 2161554 2161554 defendant Hawly Ralph yeoman 606263 606263 Hawly, Ralph, of Wynster, yeoman 1
4402222 2165330 2165330 defendant Hurde George yeoman 606263 606263 Hurde, George, of Wynster, yeoman 0
4552614 2216772 2216772 defendant Malkynson John   606263 606263 Malkynson, John, of Wynster 0
4552615 2216772 2216772 defendant Merior Thomas   606263 606263 Merior, Thomas, of Wynster 1
4552617 2216772 2216772 defendant Tomeson John   606263 606263 Tomeson, John, of Wynster 3
4552619 2216772 2216772 defendant Lane John de   606263 606263 Lane, John de, of Wynster 5
4819740 2302247 2302247 defendant Kyrkeby John de laborer 606263 606263 Kyrkeby, John de, of Wynster, laborer 13
4988652 2353562 2353562 defendant Maryot John husbandman 606263 606263 Maryot, John, of wynster, husbandman 2
4998774 2356521 2356521 defendant Maryot John husbandman 606263 606263 Maryot, John, of wynster, husbandman 2
5009979 2359790 2359790 defendant Maryot William yeoman 606263 606263 Maryot, William, of Wynster, yeoman 0
5078370 2380025 2380025 plaintiff Brodhurst William   606263 606263 Brodhurst, William, of Wynster 0
5338161 2456502 2456502 defendant Borose Roger husbandman 606263 606263 Borose, Roger, of Wynster, husbandman 0
5338165 2456502 2456502 defendant Couleshawe Thomas miner 606263 606263 Couleshawe, Thomas, of Wynster, miner 4
5344819 2458541 2458541 defendant Colyer John husbandman 606263 606263 Colyer, John, of Wynster, husbandman 6
5352633 2460919 2460919 defendant Foliambe Cecily widow 606263 606263 Foliambe, Cecily, of Wynster, widow 0
5352634 2460919 2460919 defendant Hagh Ralph gent 606263 606263 Hagh, Ralph, of Wynster, gent 1
5352635 2460919 2460919 defendant Kynder Thomas laborer 606263 606263 Kynder, Thomas, of Wynster, laborer 2
5352636 2460919 2460919 defendant Aldewerk John laborer 606263 606263 Aldewerk, John, of Wynster, laborer 3
5352637 2460919 2460919 defendant Cade Thomas laborer 606263 606263 Cade, Thomas, of Wynster, laborer 4
5431564 2484394 2484394 defendant Borose Roger husbandman 606263 606263 Borose, Roger, of Wynster, husbandman 1
5447955 2489271 2489271 defendant borose Robert husbandman 606263 606263 borose, Robert, of Wynster, husbandman 1
5460350 2493034 2493034 defendant Borose Robert husbandman 606263 606263 Borose, Robert, of Wynster, husbandman 1
5460385 2493048 2493048 defendant Borose Roger husbandman 606263 606263 Borose, Roger, of Wynster, 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);