names

44 rows where place_id = 646658

✎ 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
3892263 1987665 1987665 defendant Oxley Edward clothier 646658 646658 Oxley, Edward, of Tunbridge, Kent, clothier 0
3910308 1993765 1993765 defendant Markeley Edward clothier 646658 646658 Markeley, Edward, of Tunbridge, Kent, clothier 0
3918013 1996392 1996392 defendant Plane Michael clothier 646658 646658 Plane, Michael, of Tunbridge, Kent, clothier 0
3948286 2006461 2006461 plaintiff Crowcheman William clothier 646658 646658 Crowcheman, William, of Tunbridge, Kent, clothier 0
3967977 2013429 2013429 defendant Drewe Martin yeoman 646658 646658 Drewe, Martin, of Tunbridge, Kent, yeoman 1
3973679 2015367 2015367 defendant Skynner Edmund chapman 646658 646658 Skynner, Edmund, of Tunbridge, Kent, chapman 1
3999783 2024682 2024682 defendant Chambers Thomas saddler 646658 646658 Chambers, Thomas, of Tunbridge, Kent, saddler 2
4001715 2025389 2025389 defendant Oxley John gent 646658 646658 Oxley, John, of Tunbridge, Kent, gent 1
4004631 2026432 2026432 defendant Allen Cuthbert yeoman 646658 646658 Allen, Cuthbert, of Tunbridge, Kent, yeoman 0
4006732 2027186 2027186 defendant Oxley John gent 646658 646658 Oxley, John, of Tunbridge, Kent, gent 0
4018912 2031498 2031498 defendant Willard David yeoman 646658 646658 Willard, David, of Tunbridge, Kent, yeoman 0
4024386 2033399 2033399 defendant Drewe Martin yeoman 646658 646658 Drewe, Martin, of Tunbridge, Kent, yeoman 0
4032075 2036140 2036140 defendant Furmynger Andrew yeoman 646658 646658 Furmynger, Andrew, of Tunbridge, Kent, yeoman 0
4158695 2081114 2081114 defendant Hygges Thomas grasier 646658 646658 Hygges, Thomas, of Tunbridge, Kent, yeoman, or of Speldherst, Sussex, grasier 0
4236380 2108296 2108296 defendant Maynard John yeoman 646658 646658 Maynard, John, of Tunbridge, Kent, yeoman 1
4253498 2114159 2114159 defendant Byshoppe George yeoman 646658 646658 Byshoppe, George, of Tunbridge, Kent, yeoman 3
4253503 2114160 2114160 defendant Bisshoppe George yeoman 646658 646658 Bisshoppe, George, of Tunbridge, Kent, yeoman 3
4258712 2115878 2115878 defendant Park John yeoman 646658 646658 Park, John, of Tunbridge, Kent, yeoman 0
4258714 2115879 2115879 defendant Park John yeoman 646658 646658 Park, John, of Tunbridge, Kent, yeoman 0
4289001 2126122 2126122 defendant Willard Abraham yeoman 646658 646658 Willard, Abraham, of Tunbridge, Kent, yeoman 1
4313916 2134971 2134971 defendant Willard Edmund   646658 646658 Willard, Edmund, of Tunbridge, Kent, iron master 0
4320406 2137236 2137236 defendant Pynner Elizabeth spinster 646658 646658 Pynner, Elizabeth, of Tunbridge, Kent, spinster 0
4327338 2139467 2139467 defendant Harris William butcher 646658 646658 Harris, William, of Tunbridge, Kent, butcher 0
4328414 2139819 2139819 defendant Wyllard Edmund yeoman 646658 646658 Wyllard, Edmund, of Tunbridge, Kent, yeoman 1
4328418 2139820 2139820 defendant Willard Edmund yeoman 646658 646658 Willard, Edmund, of Tunbridge, Kent, yeoman 1
4340726 2144031 2144031 defendant Merser Ruchard yeoman 646658 646658 Merser, Ruchard, of Tunbridge, Kent, yeoman 0
4347676 2146436 2146436 defendant Stapleton Walter carpenter 646658 646658 Stapleton, Walter, of Tunbridge, Kent, carpenter 0
4359910 2150708 2150708 defendant Willard Edmund yeoman 646658 646658 Willard, Edmund, of Tunbridge, Kent, yeoman 2
4388365 2160741 2160741 defendant Cowchman Thomas yeoman 646658 646658 Cowchman, Thomas, of Tunbridge, Kent, yeoman 1
4397108 2163601 2163601 defendant Collman Rubin innholder 646658 646658 Collman, Rubin, of Tunbridge, Kent, innholder 1
4398470 2164069 2164069 defendant Children Roman yeoman 646658 646658 Children, Roman, of Tunbridge, Kent, yeoman 0
4706412 2267387 2267387 defendant Godfrey William shingler or tile maker or roofer 646658 646658 Godfrey, William, of Tunbridge, Kent, shingler or tile maker or roofer 0
4706414 2267388 2267388 defendant K_miabe John glover maker 646658 646658 K_miabe, John, of Tunbridge, Kent, glover maker 0
4755089 2281976 2281976 defendant Holden John esq 646658 646658 Holden, John, of Tunbridge, Kent, esq 0
5010760 2360002 2360002 defendant Polle John yeoman 646658 646658 Polle, John, of Tunbridge, Kent, yeoman 0
5010774 2360004 2360004 defendant Latter Robert yeoman 646658 646658 Latter, Robert, of Tunbridge, Kent, yeoman 3
5157920 2403439 2403439 defendant Bechare Thomas   646658 646658 Bechare, Thomas, of Tunbridge, Kent, blade smith 3
5173669 2407995 2407995 defendant Bechare Thomas   646658 646658 Bechare, Thomas, of Tunbridge, Kent, blade smith 2
5173680 2407996 2407996 defendant Bechare Thomas   646658 646658 Bechare, Thomas, of Tunbridge, Kent, blade smith 3
5193722 2413892 2413892 defendant Bechare Thomas   646658 646658 Bechare, Thomas, of Tunbridge, Kent, blade smith 0
5199034 2415468 2415468 defendant Rode Thomas butcher 646658 646658 Rode, Thomas, of Tunbridge, Kent, butcher 2
5208331 2418164 2418164 defendant Bechare Thomas   646658 646658 Bechare, Thomas, of Tunbridge, Kent, blade smith 0
5210899 2418920 2418920 defendant Rede Thomas butcher 646658 646658 Rede, Thomas, of Tunbridge, Kent, butcher 1
5411598 2478424 2478424 defendant Billyngton John yeoman 646658 646658 Billyngton, John, of Tunbridge, Kent, yeoman 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);