names

66 rows where place_id = 595014

✎ 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
3618488 1873408 1873408 defendant Laxton William capper 595014 595014 Laxton, William, of South Reppys, capper 0
3622352 1874527 1874527 plaintiff Powle Thomas   595014 595014 Powle, Thomas, of South Reppys 0
3659070 1913100 1913100 defendant Harward John gent 595014 595014 Harward, John, of South Reppys, gent 0
3673946 1917889 1917889 defendant Aleyn John butcher 595014 595014 Aleyn, John, of South Reppys, butcher 0
3680437 1919963 1919963 defendant Skynne William husbandman 595014 595014 Skynne, William, of South Reppys, husbandman 3
3709156 1929160 1929160 defendant Lownd William (legal representative) 595014 595014 Lownd, William, of South Reppys, yeoman, executors of 0
3709157 1929160 1929160 defendant Hobbys Thomas husbandman 595014 595014 (Hobbys, Thomas, of South Reppys, husbandman 1
3709158 1929160 1929160 defendant Lownd John husbandman 595014 595014 Lownd, John, of South Reppys, husbandman 2
3709159 1929160 1929160 defendant Gogyll Thomas shoemaker 595014 595014 Gogyll, Thomas, of South Reppys, shoemaker 3
3717098 1931631 1931631 defendant Crescey John carpenter 595014 595014 Crescey, John, of South Reppys, carpenter 1
3763639 1946267 1946267 defendant Woderowe John husbandman 595014 595014 Woderowe, John, of South Reppys, husbandman 1
3780724 1951704 1951704 defendant Flyte Thomas   595014 595014 Flyte, Thomas, of South Reppys, worsted weaver 0
3806045 1959818 1959818 defendant Woderowe John husbandman 595014 595014 Woderowe, John, of South Reppys, husbandman 0
3815709 1962832 1962832 defendant Warnys Henry butcher 595014 595014 Warnys, Henry, of South Reppys, butcher 0
3815710 1962832 1962832 defendant Smyth William   595014 595014 Smyth, William, of South Reppys, worsted weaver 1
3835219 1968955 1968955 defendant Aleyns John butcher 595014 595014 Aleyns, John, of South Reppys, butcher 0
3862669 1977709 1977709 defendant Warnes Henry butcher 595014 595014 Warnes, Henry, of South Reppys, butcher 0
3900027 1990229 1990229 plaintiff Harward John gent 595014 595014 Harward, John, of South Reppys, gent 2
3918519 1996519 1996519 defendant Hobbys Thomas husbandman 595014 595014 Hobbys, Thomas, of South Reppys, husbandman 0
4509488 2203436 2203436 plaintiff atte Lound William   595014 595014 atte Lound, William, of South Reppys 0
4821496 2302808 2302808 defendant Meller John husbandman 595014 595014 Meller, John, of South Reppys, husbandman 0
4821498 2302809 2302809 defendant Miller John husbandman 595014 595014 Miller, John, of South Reppys, husbandman 0
4858192 2313931 2313931 defendant Dengeglas John husbandman 595014 595014 Dengeglas, John, of South Reppys, husbandman 3
4975984 2349782 2349782 defendant Hardyng John (legal representative) 595014 595014 Hardyng, John, of South Reppys, baker, executors of 0
4975985 2349782 2349782 defendant Fayrcook John husbandman 595014 595014 (Fayrcook, John, of South Reppys, husbandman 1
5098449 2385976 2385976 defendant Kedilham Thomas yeoman 595014 595014 Kedilham, Thomas, of South Reppys, yeoman 0
5104241 2387663 2387663 defendant Kedylham Thomas yeoman 595014 595014 Kedylham, Thomas, of South Reppys, yeoman 1
5104242 2387663 2387663 defendant Clerk Adam yeoman 595014 595014 Clerk, Adam, of South Reppys, yeoman 2
5116036 2391118 2391118 defendant Bryght Thomas fuller 595014 595014 Bryght, Thomas, of South Reppys, fuller 3
5125879 2394056 2394056 defendant Kydlam Thomas yeoman 595014 595014 Kydlam, Thomas, of South Reppys, yeoman 0
5126108 2394117 2394117 defendant Kedilham Thomas yeoman 595014 595014 Kedilham, Thomas, of South Reppys, yeoman 7
5138538 2397770 2397770 defendant Sweyn John husbandman 595014 595014 Sweyn, John, of South Reppys, husbandman 2
5139008 2397900 2397900 defendant Kedilham Thomas   595014 595014 Kedilham, Thomas, of South Reppys 0
5144488 2399549 2399549 defendant Kydlam Thomas yeoman 595014 595014 Kydlam, Thomas, of South Reppys, yeoman 0
5146359 2400067 2400067 defendant Kedilham Thomas yeoman 595014 595014 Kedilham, Thomas, of South Reppys, yeoman 5
5147379 2400379 2400379 defendant Douglas Thomas   595014 595014 Douglas, Thomas, of South Reppys, mason 0
5214369 2419935 2419935 defendant Kedylham Thomas yeoman 595014 595014 Kedylham, Thomas, of South Reppys, yeoman 3
5284762 2440561 2440561 defendant Marsham Andrew yeoman 595014 595014 Marsham, Andrew, of South Reppys, yeoman 0
5285715 2440850 2440850 plaintiff Hanworth Nicholas   595014 595014 Hanworth, Nicholas, of South Reppys 0
5285716 2440850 2440850 plaintiff Portere Adam   595014 595014 Portere, Adam, of South Reppys 1
5288827 2441743 2441743 defendant Norfolk John yeoman 595014 595014 Norfolk, John, of South Reppys, yeoman 3
5288828 2441743 2441743 defendant Deynys William chaplain 595014 595014 Deynys, William, of South Reppys, chaplain 4
5299621 2444860 2444860 defendant Lodysham Thomas yeoman 595014 595014 Lodysham, Thomas, of South Reppys, yeoman 2
5333386 2455057 2455057 defendant Marsham Andrew butcher 595014 595014 Marsham, Andrew, of South Reppys, butcher 8
5359402 2462976 2462976 defendant Clerke Adam (legal representative) 595014 595014 Clerke, Adam, of South Reppys, husbandman, administratrix of 5
5359403 2462976 2462976 defendant Clerke Joan widow 595014 595014 Clerke, Joan, of South Reppys, widow 6
5384755 2470725 2470725 defendant Neuman William husbandman 595014 595014 Neuman, William, of South Reppys, husbandman 0
5384784 2470725 2470725 defendant Clerk Adam   595014 595014 Clerk, Adam, of South Reppys, yeoman, administrators 29
5384785 2470725 2470725 defendant Clerk John husbandman 595014 595014 (Clerk, John, of South Reppys, husbandman 30
5396772 2474170 2474170 defendant Neuman William   595014 595014 Neuman, William, of South Reppys 0
5396801 2474170 2474170 defendant Clerk Adam   595014 595014 Clerk, Adam, of South Reppys, yeoman, administrators of 29
5396802 2474170 2474170 defendant Clerk John   595014 595014 (Clerk, John, of South Reppys 30
5410017 2477962 2477962 defendant Neuman William husbandman 595014 595014 Neuman, William, of South Reppys, husbandman 0
5410044 2477962 2477962 defendant Clerk Adam   595014 595014 Clerk, Adam, of South Reppys, administrators of 27
5410045 2477962 2477962 defendant Clerk John husbandman 595014 595014 (Clerk, John, of South Reppys, husbandman 28
5412234 2478614 2478614 defendant Rysburgh Simon husbandman 595014 595014 Rysburgh, Simon, of South Reppys, husbandman 1
5471454 2496407 2496407 defendant Neweman William husbandman 595014 595014 Neweman, William, of South Reppys, husbandman 1
5490745 2502122 2502122 defendant Neweman William husbandman 595014 595014 Neweman, William, of South Reppys, husbandman 6
5558709 2522500 2522500 plaintiff Aleyn Robert husbandman 595014 595014 Aleyn, Robert, of South Reppys, husbandman 3
5562303 2523572 2523572 defendant Bery Thomas husbandman 595014 595014 Bery, Thomas, of South Reppys, husbandman 0
5578544 2528361 2528361 defendant Toppys William (legal representative) 595014 595014 Toppys, William, of South Reppys, yeoman, executrix of 0
5578545 2528361 2528361 defendant Toppys Agnes widow 595014 595014 Toppys, Agnes, of South Reppys, widow 1
5578549 2528361 2528361 defendant Blakeman Thomas (legal representative) 595014 595014 Blakeman, Thomas, of South Reppys, yeoman, executor of 5
5600296 2534979 2534979 plaintiff Herward John gent 595014 595014 Herward, John, of South Reppys, gent 0
5609702 2537930 2537930 defendant at Hoo John (legal representative) 595014 595014 at Hoo, John, of South Reppys, yeoman, executrix of 0
5609703 2537930 2537930 defendant at Hoo Margaret widow 595014 595014 at Hoo, Margaret, of South Reppys, widow 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);