names

32 rows where place_id = 656746

✎ 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
3941573 2004194 2004194 defendant Cowper John husbandman 656746 656746 Cowper, John, of Cumberworth, husbandman 0
4060232 2046061 2046061 defendant Tompson Christopher carpenter 656746 656746 Tompson, Christopher, of Cumberworth, carpenter 0
4063716 2047313 2047313 defendant Wylkinson William husbandman 656746 656746 Wylkinson, William, of Cumberworth, husbandman 0
4169875 2084960 2084960 defendant Heardman John yeoman 656746 656746 Heardman, John, of Cumberworth, yeoman 1
4188811 2091565 2091565 defendant Toynton Robert husbandman 656746 656746 Toynton, Robert, of Cumberworth, husbandman 3
4189945 2091986 2091986 defendant Toynton Robert husbandman 656746 656746 Toynton, Robert, of Cumberworth, husbandman 3
4396410 2163373 2163373 defendant Butteroyd Richard husbandman 656746 656746 Butteroyd, Richard, of Cumberworth, husbandman 3
4508505 2203134 2203134 plaintiff Alanson John   656746 656746 Alanson, John, of Cumberworth, son of William 0
4539859 2212730 2212730 plaintiff Walton Thomas de   656746 656746 Walton, Thomas de, of Cumberworth 0
4548513 2215478 2215478 plaintiff Cisson Robert   656746 656746 Cisson, Robert, of Cumberworth 0
4593211 2229172 2229172 defendant Walton John   656746 656746 Walton, John, of Cumberworth 3
4688433 2261949 2261949 plaintiff Tetenay John   656746 656746 Tetenay, John, of Cumberworth, parson 0
4709924 2268462 2268462 defendant Kitwon William husbandman 656746 656746 Kitwon, William, of Cumberworth, husbandman 1
4709925 2268462 2268462 defendant Josep' John husbandman 656746 656746 Josep', John, of Cumberworth, husbandman 2
4709926 2268462 2268462 defendant Hudson John collier 656746 656746 Hudson, John, of Cumberworth, collier 3
4801355 2296614 2296614 defendant Josep John husbandman 656746 656746 Josep, John, of Cumberworth, husbandman 0
4801356 2296614 2296614 defendant Josep William husbandman 656746 656746 Josep, William, of Cumberworth, husbandman 1
4801357 2296614 2296614 defendant Huddeson John husbandman 656746 656746 Huddeson, John, of Cumberworth, husbandman 2
4801363 2296616 2296616 defendant Nicolas Richard husbandman 656746 656746 Nicolas, Richard, of Cumberworth, husbandman 0
4801364 2296616 2296616 defendant Luppyshed John husbandman 656746 656746 Luppyshed, John, of Cumberworth, husbandman 1
4801365 2296616 2296616 defendant Hudson John husbandman 656746 656746 Hudson, John, of Cumberworth, husbandman 2
4939873 2338860 2338860 defendant Mykylbergh John clerk 656746 656746 Mykylbergh, John, of Cumberworth, clerk 0
4939874 2338860 2338860 defendant Walton John husbandman 656746 656746 Walton, John, of Cumberworth, husbandman 1
5001257 2357247 2357247 plaintiff Mekylbergh John (legal representative) 656746 656746 Mekylbergh, John, of Cumberworth, parson, executors of 0
5001494 2357328 2357328 plaintiff Mikelbergh John (legal representative) 656746 656746 Mikelbergh, John, of Cumberworth, parson, executors of 0
5227065 2423572 2423572 plaintiff Taillour William   656746 656746 Taillour, William, of Cumberworth 0
5227295 2423612 2423612 plaintiff Tayllour William   656746 656746 Tayllour, William, of Cumberworth 0
5264762 2434737 2434737 defendant West John husbandman 656746 656746 West, John, of Cumberworth, husbandman 0
5533378 2514989 2514989 defendant Heweson John husbandman 656746 656746 Heweson, John, of Cumberworth, husbandman 0
5536136 2515792 2515792 defendant Walton Thomas clerk 656746 656746 Walton, Thomas, of Cumberworth, clerk 9
5624779 2551681 2551681 defendant Walton John husbandman 656746 656746 Walton, John, of Cumberworth, husbandman 0
5624807 2551689 2551689 defendant Walton John husbandman 656746 656746 Walton, John, of Cumberworth, 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);