names

43 rows where place_id = 591888

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3605891 1869506 1869506 defendant Faukener John yeoman 591888 591888 Faukener, John, of Couteshale, yeoman 5
3753616 1943075 1943075 plaintiff Baspole Ralph   591888 591888 (Baspole, Ralph, of Couteshale 1
3753621 1943076 1943076 plaintiff Baspole Ralph   591888 591888 (Baspole, Ralph, of Couteshale 1
3804732 1959427 1959427 plaintiff Baspole Robert   591888 591888 (Baspole, Robert, of Couteshale 1
4438479 2181322 2181322 defendant Prymerose John   591888 591888 Prymerose, John, of Couteshale 1
4628657 2239886 2239886 defendant Bowre William   591888 591888 Bowre, William, of Couteshale 0
4654964 2247435 2247435 defendant Chylde Simon husbandman 591888 591888 Chylde, Simon, of Couteshale, husbandman 3
4778031 2289115 2289115 defendant Dam John laborer 591888 591888 Dam, John, of Couteshale, laborer 2
4897841 2325987 2325987 plaintiff Stannard John (legal representative) 591888 591888 Stannard, John, of Couteshale, executors of 0
4939930 2338874 2338874 defendant Crundale Thomas clerk 591888 591888 Crundale, Thomas, of Couteshale, clerk 0
4957662 2344265 2344265 defendant Sweyn Robert yeoman 591888 591888 Sweyn, Robert, of Couteshale, yeoman 1
4967255 2347142 2347142 defendant Landon John miller 591888 591888 Landon, John, of Couteshale, miller 0
5025409 2364328 2364328 defendant Brakle John fuller 591888 591888 Brakle, John, of Couteshale, fuller 1
5032699 2366448 2366448 defendant Swayn Robert husbandman 591888 591888 Swayn, Robert, of Couteshale, husbandman 0
5037634 2367882 2367882 defendant Willyams Richard butcher 591888 591888 Willyams, Richard, of Couteshale, butcher 1
5087448 2382705 2382705 defendant Brynyng John husbandman 591888 591888 Brynyng, John, of Couteshale, husbandman 1
5093218 2384409 2384409 defendant atte Stonys Nicholas husbandman 591888 591888 atte Stonys, Nicholas, of Couteshale, husbandman 1
5103583 2387475 2387475 defendant Hancok Thomas clerk 591888 591888 Hancok, Thomas, of Couteshale, clerk 0
5105248 2387975 2387975 defendant Sweyn Robert yeoman 591888 591888 Sweyn, Robert, of Couteshale, yeoman 0
5111884 2389864 2389864 defendant Fletcher John husbandman 591888 591888 Fletcher, John, of Couteshale, husbandman 3
5132630 2396039 2396039 defendant Emson William laborer 591888 591888 Emson, William, of Couteshale, laborer 0
5266685 2435335 2435335 defendant Kyse or Dyse William husbandman 591888 591888 Kyse or Dyse, William, of Couteshale, husbandman 0
5266686 2435335 2435335 defendant Mowetyng William husbandman 591888 591888 Mowetyng, William, of Couteshale, husbandman 1
5275038 2437780 2437780 defendant Blakbourn William husbandman 591888 591888 Blakbourn, William, of Couteshale, husbandman 1
5291225 2442436 2442436 defendant Cok John husbandman 591888 591888 Cok, John, of Couteshale, husbandman 2
5333382 2455057 2455057 defendant Bryngyng John husbandman 591888 591888 Bryngyng, John, of Couteshale, husbandman 4
5347616 2459409 2459409 defendant Spenyng or Spekenyng Henry yeoman 591888 591888 Spenyng or Spekenyng, Henry, of Couteshale, yeoman 0
5351742 2460644 2460644 defendant Cokke John husbandman 591888 591888 Cokke, John, of Couteshale, husbandman 0
5388667 2471815 2471815 plaintiff Hart John (legal representative) 591888 591888 Hart, John, of Couteshale, husbandman, executors of 0
5398507 2474631 2474631 defendant Caley Thomas smith 591888 591888 Caley, Thomas, of Couteshale, smith 1
5434775 2485340 2485340 defendant Hert Thomas husbandman 591888 591888 Hert, Thomas, of Couteshale, husbandman 2
5450076 2489911 2489911 defendant Hert Thomas husbandman 591888 591888 Hert, Thomas, of Couteshale, husbandman 1
5479898 2498999 2498999 defendant Hert Thomas husbandman 591888 591888 Hert, Thomas, of Couteshale, husbandman 0
5481954 2499535 2499535 defendant Hert Thomas yeoman 591888 591888 Hert, Thomas, of Couteshale, yeoman 0
5496393 2503827 2503827 defendant Lane Robert yeoman 591888 591888 Lane, Robert, of Couteshale, yeoman 0
5503146 2505895 2505895 defendant Huchon Peter cpicer 591888 591888 Huchon, Peter, of Couteshale, cpicer 1
5505213 2506540 2506540 defendant Bryghtwell John husbandman 591888 591888 Bryghtwell, John, of Couteshale, husbandman 0
5527227 2513095 2513095 defendant Godewyn Richard butcher 591888 591888 Godewyn, Richard, of Couteshale, butcher 0
5534149 2515214 2515214 defendant Goodwyn Richard   591888 591888 Goodwyn, Richard, of Couteshale, but cher 1
5579998 2528825 2528825 defendant Lane Richard yeoman 591888 591888 Lane, Richard, of Couteshale, yeoman 0
5580010 2528827 2528827 defendant Lane Robert yeoman 591888 591888 Lane, Robert, of Couteshale, yeoman 2
5629025 2553047 2553047 defendant Edes William weaver 591888 591888 Edes, William, of Couteshale, weaver 0
5629026 2553047 2553047 defendant Edes Simon weaver 591888 591888 Edes, Simon, of Couteshale, weaver 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);