names

64 rows where place_id = 604024

✎ 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
3656601 1912318 1912318 defendant Marshall John yeoman 604024 604024 Marshall, John, of Dartford, Kent, yeoman 0
3674411 1918041 1918041 defendant Goodborow Martin yeoman 604024 604024 Goodborow, Martin, of Dartford, Kent, yeoman 1
3679184 1919557 1919557 defendant Stoughton Thomas mercer 604024 604024 Stoughton, Thomas, of Dartford, Kent, mercer 0
3692052 1923683 1923683 defendant Whitefeld John butcher 604024 604024 Whitefeld, John, of Dartford, Kent, butcher 0
3701150 1926608 1926608 defendant Stokemede William yeoman 604024 604024 Stokemede, William, of Dartford, Kent, yeoman 0
3705724 1928074 1928074 defendant Cowley Beatrice widow 604024 604024 Cowley, Beatrice, of Dartford, Kent, widow 0
3723402 1933587 1933587 defendant Hartt John fishmonger 604024 604024 Hartt, John, of Dartford, Kent, fishmonger 1
3756875 1944124 1944124 defendant Appulton Henry gent 604024 604024 Appulton, Henry, of Dartford, Kent, gent 0
3759476 1944957 1944957 defendant Hart John yeoman 604024 604024 Hart, John, of Dartford, Kent, yeoman 3
3821541 1964633 1964633 defendant Bond John yeoman 604024 604024 Bond, John, of Dartford, Kent, yeoman 3
3899568 1990073 1990073 defendant Thomson John   604024 604024 Thomson, John, of Dartford, Kent 0
3923711 1998240 1998240 defendant Watson Thomas smith 604024 604024 Watson, Thomas, of Dartford, Kent, smith 3
3923912 1998309 1998309 defendant Asshewell Henry yeoman 604024 604024 Asshewell, Henry, of Dartford, Kent, yeoman 1
3923926 1998312 1998312 defendant Asshewell Henry yeoman 604024 604024 Asshewell, Henry, of Dartford, Kent, yeoman 1
3941126 2004034 2004034 defendant Rychardson Edmund chapman 604024 604024 Rychardson, Edmund, of Dartford, Kent, chapman 3
3977830 2016818 2016818 defendant Gamble John yeoman 604024 604024 Gamble, John, of Dartford, Kent, yeoman 1
4020160 2031933 2031933 defendant Cobbe Thomas yeoman 604024 604024 Cobbe, Thomas, of Dartford, Kent, yeoman 0
4020164 2031934 2031934 defendant Cobbe Thomas yeoman 604024 604024 Cobbe, Thomas, of Dartford, Kent, yeoman 0
4026641 2034175 2034175 plaintiff Camberleyn Christopher (legal representative) 604024 604024 Camberleyn, Christopher, of Dartford, Kent, gent, administrator of 0
4027472 2034473 2034473 defendant Appelton William gent 604024 604024 Appelton, William, of Dartford, Kent, gent 0
4045064 2040689 2040689 defendant Appleton William gent 604024 604024 Appleton, William, of Dartford, Kent, gent 0
4051044 2042812 2042812 defendant Rawson William innholder 604024 604024 Rawson, William, of Dartford, Kent, innholder 1
4054027 2043821 2043821 defendant Beere Nicholas gent 604024 604024 Beere, Nicholas, of Dartford, Kent, gent 1
4063320 2047172 2047172 defendant Cotman John chandler 604024 604024 Cotman, John, of Dartford, Kent, chandler 0
4075994 2051711 2051711 defendant Pears Francis yeoman 604024 604024 Pears, Francis, of Dartford, Kent, yeoman 0
4117645 2066607 2066607 defendant Francketon John chapman 604024 604024 Francketon, John, of Dartford, Kent, chapman 2
4202812 2096528 2096528 defendant Wattes Percival tailor 604024 604024 Wattes, Percival, of Dartford, Kent, tailor 0
4206727 2097892 2097892 defendant Rogers Francis gent 604024 604024 Rogers, Francis, of Dartford, Kent, gent 1
4261737 2116880 2116880 defendant Rogers Francis gent 604024 604024 Rogers, Francis, of Dartford, Kent, gent 1
4266380 2118399 2118399 defendant Bevington Richard glasier 604024 604024 Bevington, Richard, of Dartford, Kent, glasier 1
4267495 2118763 2118763 defendant Gaylor William yeoman 604024 604024 Gaylor, William, of Dartford, Kent, yeoman 0
4344005 2145181 2145181 defendant Hudson Gawin yeoman 604024 604024 Hudson, Gawin, of Dartford, Kent, yeoman 0
4400562 2164779 2164779 defendant Dunche Thomas yeoman 604024 604024 Dunche, Thomas, of Dartford, Kent, yeoman 1
4749818 2280421 2280421 defendant Bonour John yeoman 604024 604024 Bonour, John, of Dartford, Kent, yeoman 0
4760436 2283617 2283617 defendant Skarlet Thomas dyer 604024 604024 Skarlet, Thomas, of Dartford, Kent, dyer 0
4772929 2287503 2287503 defendant Dancastre William chapman 604024 604024 Dancastre, William, of Dartford, Kent, chapman 1
4838032 2307819 2307819 defendant Taillour John (legal representative) 604024 604024 Taillour, John, of Dartford, Kent, executors of 0
4845107 2309986 2309986 defendant Howeton Thomas yeoman 604024 604024 Howeton, Thomas, of Dartford, Kent, yeoman 1
4914014 2330893 2330893 defendant Martyn John gent 604024 604024 Martyn, John, of Dartford, Kent, gent 1
5004342 2358165 2358165 defendant Cooke Richard fishmonger 604024 604024 Cooke, Richard, of Dartford, Kent, fishmonger 0
5144258 2399476 2399476 defendant Stokemede William baker 604024 604024 Stokemede, William, of Dartford, Kent, baker 0
5144384 2399514 2399514 plaintiff (not given) Margaret prioress of Beaumont 604024 604024 Beaumont, Margaret, of Dartford, Kent, prioress of the house & church 0
5148567 2400707 2400707 defendant Gulbyn Thomas   604024 604024 Gulbyn, Thomas, of Dartford, Kent, wax chandler 3
5151690 2401653 2401653 defendant Worth William yeoman 604024 604024 Worth, William, of Dartford, Kent, yeoman 0
5151692 2401654 2401654 defendant Worth William yeoman 604024 604024 Worth, William, of Dartford, Kent, yeoman 0
5156996 2403188 2403188 defendant Baker John hostiller 604024 604024 Baker, John, of Dartford, Kent, hostiller 0
5165173 2405557 2405557 defendant Stokmede William baker 604024 604024 Stokmede, William, of Dartford, Kent, baker 0
5165258 2405582 2405582 plaintiff (not given) Margaret prioress of Beaumont 604024 604024 Beaumont, Margaret, of Dartford, Kent, prioress of the house & church 0
5173041 2407828 2407828 defendant Baker John hosteller 604024 604024 Baker, John, of Dartford, Kent, hosteller 0
5178946 2409571 2409571 defendant Stokmede William baker 604024 604024 Stokmede, William, of Dartford, Kent, baker 0
5192873 2413638 2413638 defendant Baker John hostiller 604024 604024 Baker, John, of Dartford, Kent, hostiller 0
5201685 2416261 2416261 defendant Stokmede William baker 604024 604024 Stokmede, William, of Dartford, Kent, baker 0
5205407 2417335 2417335 defendant Worth William yeoman 604024 604024 Worth, William, of Dartford, Kent, yeoman 0
5210620 2418846 2418846 defendant Worth William yeoman 604024 604024 Worth, William, of Dartford, Kent, yeoman 0
5245115 2428736 2428736 defendant Thorp Thomas esq 604024 604024 Thorp, Thomas, of Dartford, Kent, esq 3
5272547 2437046 2437046 defendant Salet John smith 604024 604024 Salet, John, of Dartford, Kent, smith 2
5299045 2444701 2444701 defendant Appulton Roger gent 604024 604024 Appulton, Roger, of Dartford, Kent, gent 3
5310161 2448071 2448071 defendant Cotys Robert gent 604024 604024 Cotys, Robert, of Dartford, Kent, gent 0
5310733 2448245 2448245 defendant Blaknall John husbandman 604024 604024 Blaknall, John, of Dartford, Kent, husbandman 2
5376126 2468124 2468124 defendant Chertesey William esq 604024 604024 Chertesey, William, of Dartford, Kent, esq 0
5388620 2471801 2471801 defendant Chartesey William gent 604024 604024 Chartesey, William, of Dartford, Kent, gent 0
5409419 2477781 2477781 defendant Putnam Robert dyer 604024 604024 Putnam, Robert, of Dartford, Kent, dyer 1
5418393 2480429 2480429 defendant Chartesey William esq 604024 604024 Chartesey, William, of Dartford, Kent, esq 0
5422954 2481820 2481820 plaintiff Bentele William (legal representative) 604024 604024 Bentele, William, of Dartford, Kent, dyer, executors of 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);