names

60 rows where place_id = 591566

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604844 1869181 1869181 defendant Boothe Robert gent 591566 591566 Boothe, Robert, of Bromley, Kent, gent 3
3604861 1869186 1869186 defendant Boothe Robert gent 591566 591566 Boothe, Robert, of Bromley, Kent, gent 1
3716300 1931391 1931391 defendant Cryer William husbandman 591566 591566 Cryer, William, of Bromley, Kent, husbandman 0
3748793 1941557 1941557 defendant Bedyll John husbandman 591566 591566 Bedyll, John, of Bromley, Kent, husbandman 0
3769024 1947962 1947962 defendant Wryght Ralph cordwainer 591566 591566 Wryght, Ralph, of Bromley, Kent, cordwainer 0
4073218 2050712 2050712 defendant Petley John gent 591566 591566 Petley, John, of Bromley, Kent, gent 0
4125459 2069387 2069387 defendant Mathewe Richard collier 591566 591566 Mathewe, Richard, of Bromley, Kent, collier 0
4138897 2074285 2074285 defendant Hopton Robert esq 591566 591566 Hopton, Robert, of Bromley, Kent, esq 0
4159313 2081327 2081327 defendant Mathewe Thomas yeoman 591566 591566 Mathewe, Thomas, of Bromley, Kent, yeoman 0
4175859 2087031 2087031 defendant Beste Thomas, junior husbandman 591566 591566 Beste, Thomas, junior, of Bromley, Kent, husbandman 1
4210760 2099320 2099320 defendant Hopton Robert esq 591566 591566 Hopton, Robert, of Bromley, Kent, esq 0
4269640 2119436 2119436 defendant Glover John tailor 591566 591566 Glover, John, of Bromley, Kent, tailor 0
4361054 2151124 2151124 defendant Evered Thomas yeoman 591566 591566 Evered, Thomas, of Bromley, Kent, yeoman 3
4387426 2160439 2160439 defendant Thornhill Richard gent 591566 591566 Thornhill, Richard, of Bromley, Kent, gent 0
4391249 2161691 2161691 defendant Goslinge or Goslyn William gent 591566 591566 Goslinge or Goslyn, William, of Bromley, Kent, gent 1
4729287 2274376 2274376 defendant Rose Alice widow 591566 591566 Rose, Alice, of Bromley, Kent, widow 0
4986783 2352984 2352984 defendant Aleyn John gent 591566 591566 Aleyn, John, of Bromley, Kent, gent 0
5010569 2359965 2359965 defendant Gargrave William esq 591566 591566 Gargrave, William, of Bromley, Kent, esq 3
5107044 2388491 2388491 defendant Nicolet John yeoman 591566 591566 Nicolet, John, of Bromley, Kent, yeoman 1
5110360 2389434 2389434 defendant Shelton John husbandman 591566 591566 Shelton, John, of Bromley, Kent, husbandman 1
5116745 2391331 2391331 defendant Niclot John   591566 591566 Niclot, John, of Bromley, Kent, carpenter, or of Adyngton, Surrey, wheelwright 3
5126554 2394241 2394241 defendant Londres John yeoman 591566 591566 Londres, John, of Bromley, Kent, yeoman 3
5127874 2394631 2394631 defendant Jeweller John husbandman 591566 591566 Jeweller, John, of Bromley, Kent, husbandman 0
5127875 2394631 2394631 defendant Cook Robert husbandman 591566 591566 Cook, Robert, of Bromley, Kent, husbandman 1
5145236 2399747 2399747 defendant Londres John yeoman 591566 591566 Londres, John, of Bromley, Kent, yeoman 1
5198503 2415314 2415314 defendant Bernard William yeoman 591566 591566 Bernard, William, of Bromley, Kent, yeoman 1
5210571 2418828 2418828 defendant Bernard William yeoman 591566 591566 Bernard, William, of Bromley, Kent, yeoman 1
5210575 2418829 2418829 defendant Bernard William yeoman 591566 591566 Bernard, William, of Bromley, Kent, yeoman 1
5211428 2419075 2419075 defendant Bernard William tailor 591566 591566 Bernard, William, of Bromley, Kent, tailor 0
5224937 2422966 2422966 defendant Shot Andrew husbandman 591566 591566 Shot, Andrew, of Bromley, Kent, husbandman 1
5237787 2426637 2426637 defendant Maas John husbandman 591566 591566 Maas, John, of Bromley, Kent, husbandman 0
5257506 2432468 2432468 defendant Payn Robert yeoman 591566 591566 Payn, Robert, of Bromley, Kent, yeoman 0
5272532 2437040 2437040 defendant Say Edmund gent 591566 591566 Say, Edmund, of Bromley, Kent, gent 2
5273149 2437218 2437218 defendant Knyght Robert husbandman 591566 591566 Knyght, Robert, of Bromley, Kent, husbandman 0
5288708 2441716 2441716 defendant Bocher John butcher 591566 591566 Bocher, John, of Bromley, Kent, butcher 2
5288919 2441765 2441765 defendant Knyght Robert husbandman 591566 591566 Knyght, Robert, of Bromley, Kent, husbandman 0
5302731 2445798 2445798 defendant Bothe Ralph gent 591566 591566 Bothe, Ralph, of Bromley, Kent, gent 1
5302734 2445799 2445799 defendant Bothe Ralph gent 591566 591566 Bothe, Ralph, of Bromley, Kent, gent 1
5309693 2447935 2447935 defendant Kethill Simon yeoman 591566 591566 Kethill, Simon, of Bromley, Kent, yeoman 1
5313551 2449081 2449081 defendant Bedyll Thomas yeoman 591566 591566 Bedyll, Thomas, of Bromley, Kent, yeoman 0
5313554 2449082 2449082 defendant Bedyll Thomas yeoman 591566 591566 Bedyll, Thomas, of Bromley, Kent, yeoman 0
5336376 2455948 2455948 defendant Birddesley Thomas husbandman 591566 591566 Birddesley, Thomas, of Bromley, Kent, husbandman 0
5336381 2455949 2455949 defendant Birddesley Thomas husbandman 591566 591566 together with Birddesley, Thomas, of Bromley, Kent, husbandman 1
5360767 2463399 2463399 defendant Shepard John husbandman 591566 591566 Shepard, John, of Bromley, Kent, husbandman 0
5376253 2468166 2468166 defendant Newenton Robert yeoman 591566 591566 Newenton, Robert, of Bromley, Kent, yeoman 1
5388751 2471840 2471840 defendant Shotte Robert yeoman 591566 591566 Shotte, Robert, of Bromley, Kent, yeoman 1
5401240 2475414 2475414 defendant Bedell Thomas yeoman 591566 591566 Bedell, Thomas, of Bromley, Kent, yeoman 0
5414383 2479240 2479240 defendant Bedell Thomas yeoman 591566 591566 Bedell, Thomas, of Bromley, Kent, yeoman 0
5421068 2481232 2481232 defendant Bedell Thomas yeoman 591566 591566 Bedell, Thomas, of Bromley, Kent, yeoman 1
5453340 2490883 2490883 defendant Bothe Randolf gent 591566 591566 Bothe, Randolf, of Bromley, Kent, gent 0
5463094 2493875 2493875 defendant Bedyll Thomas yeoman 591566 591566 Bedyll, Thomas, of Bromley, Kent, yeoman 0
5467090 2495103 2495103 defendant Bedyll Thomas yeoman 591566 591566 Bedyll, Thomas, of Bromley, Kent, yeoman 0
5486655 2500906 2500906 defendant Bedyll Thomas yeoman 591566 591566 Bedyll, Thomas, of Bromley, Kent, yeoman 0
5486657 2500907 2500907 defendant Bedyll Thomas yeoman 591566 591566 Bedyll, Thomas, of Bromley, Kent, yeoman 0
5515815 2509793 2509793 defendant Kyng Thomas yeoman 591566 591566 Kyng, Thomas, of Bromley, Kent, yeoman 0
5575968 2527558 2527558 defendant Croxton William husbandman 591566 591566 Croxton, William, of Bromley, Kent, husbandman 0
5578074 2528212 2528212 defendant Croxston William yeoman 591566 591566 Croxston, William, of Bromley, Kent, yeoman 1
5578077 2528213 2528213 defendant Croxston William yeoman 591566 591566 Croxston, William, of Bromley, Kent, yeoman 1
5591265 2532235 2532235 defendant Miller William gent 591566 591566 Miller, William, of Bromley, Kent, gent 0
5596842 2533933 2533933 defendant Bedyll Thomas yeoman 591566 591566 Bedyll, Thomas, of Bromley, 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);