names

64 rows where place_id = 594980

✎ 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
3618351 1873371 1873371 defendant Grigge John beer brewer 594980 594980 Grigge, John, of Gravesende, Kent, beer brewer 0
3623962 1875025 1875025 defendant Folde John tailor 594980 594980 Folde, John, of Gravesende, Kent, tailor 3
3687956 1922393 1922393 defendant Buston William yeoman 594980 594980 Buston, William, of Gravesende, Kent, yeoman 0
3838703 1970031 1970031 defendant Justice John yeoman 594980 594980 Justice, John, of Gravesende, Kent, yeoman 2
3839220 1970194 1970194 defendant Brownyng Robert yeoman 594980 594980 Brownyng, Robert, of Gravesende, Kent, yeoman 0
3915002 1995371 1995371 defendant Newman John yeoman 594980 594980 Newman, John, of Gravesende, Kent, yeoman 0
3955412 2008959 2008959 defendant Basse William yeoman 594980 594980 Basse, William, of Gravesende, Kent, yeoman 0
3993539 2022434 2022434 defendant Barnam Hugh yeoman 594980 594980 Barnam, Hugh, of Gravesende, Kent, yeoman 2
4006914 2027247 2027247 defendant Darbyshere William yeoman 594980 594980 (Darbyshere, William, of Gravesende, Kent, yeoman 1
4006916 2027247 2027247 defendant Darbyshere John yeoman 594980 594980 Darbyshere, John, of Gravesende, Kent, yeoman 3
4006921 2027249 2027249 defendant Darbyshere William yeoman 594980 594980 (Darbyshere, William, of Gravesende, Kent, yeoman 1
4029932 2035350 2035350 defendant Bawdwyn John postmaster 594980 594980 Bawdwyn, John, of Gravesende, Kent, postmaster 0
4100268 2060431 2060431 defendant Fryer John gent 594980 594980 Fryer, John, of Gravesende, Kent, gent 0
4131126 2071449 2071449 defendant Steede Robert chapman 594980 594980 Steede, Robert, of Gravesende, Kent, chapman 2
4205845 2097590 2097590 defendant Holland Robert clerk 594980 594980 Holland, Robert, of Gravesende, Kent, clerk 2
4210572 2099253 2099253 defendant Whiskett John vintner 594980 594980 Whiskett, John, of Gravesende, Kent, husbandman, or of Fryerninge, Essex, vintner 1
4225333 2104327 2104327 defendant Blome William yeoman 594980 594980 Blome, William, of Gravesende, Kent, yeoman 0
4332547 2141174 2141174 defendant Potter Robert gent 594980 594980 Potter, Robert, of Gravesende, Kent, gent 0
4354007 2148628 2148628 defendant Frier James scrivener 594980 594980 Frier, James, of Gravesende, Kent, scrivener 0
4651737 2246508 2246508 defendant Petygo John yeoman 594980 594980 Petygo, John, of Gravesende, Kent, yeoman 16
4733125 2275537 2275537 defendant Spycer William shipman 594980 594980 Spycer, William, of Gravesende, Kent, shipman 2
4822744 2303193 2303193 defendant Monden Nicholas husbandman 594980 594980 Monden, Nicholas, of Gravesende, Kent, husbandman 0
4822747 2303194 2303194 defendant Munden Nicholas husbandman 594980 594980 Munden, Nicholas, of Gravesende, Kent, husbandman 0
4862360 2315236 2315236 defendant Moorton Thomas hosteler 594980 594980 Moorton, Thomas, of Gravesende, Kent, hosteler 2
4894689 2325010 2325010 defendant Thorneton John yeoman 594980 594980 Thorneton, John, of Gravesende, Kent, yeoman 1
4943071 2339807 2339807 defendant Clerk William butcher 594980 594980 Clerk, William, of Gravesende, Kent, butcher 0
5028711 2365273 2365273 defendant Mersshe John yeoman 594980 594980 Mersshe, John, of Gravesende, Kent, yeoman 0
5030039 2365654 2365654 defendant Bote Robert yeoman 594980 594980 Bote, Robert, of Gravesende, Kent, yeoman 0
5032424 2366365 2366365 defendant Thornton Thomas hackneyman 594980 594980 Thornton, Thomas, of Gravesende, Kent, hackneyman 1
5041521 2369066 2369066 defendant Bot Robert yeoman 594980 594980 Bot, Robert, of Gravesende, Kent, yeoman 2
5170865 2407204 2407204 defendant Clerk William butcher 594980 594980 Clerk, William, of Gravesende, Kent, butcher 0
5228709 2424006 2424006 defendant Clerke William butcher 594980 594980 Clerke, William, of Gravesende, Kent, butcher 2
5234350 2425635 2425635 defendant Glover John ostler 594980 594980 Glover, John, of Gravesende, Kent, ostler 1
5277985 2438649 2438649 defendant Botte Robert chapman 594980 594980 Botte, Robert, of Gravesende, Kent, chapman 0
5279809 2439178 2439178 defendant Doget John yeoman 594980 594980 Doget, John, of Gravesende, Kent, yeoman 0
5279815 2439179 2439179 defendant Doget John yeoman 594980 594980 Doget, John, of Gravesende, Kent, yeoman 0
5289387 2441899 2441899 defendant Bedyll Mathew yeoman 594980 594980 Bedyll, Mathew, of Gravesende, Kent, yeoman 0
5292577 2442825 2442825 defendant Hardy Thomas mariner 594980 594980 Hardy, Thomas, of Gravesende, Kent, mariner 0
5292753 2442878 2442878 defendant Mendewe or Mendam Stephen ironmonger 594980 594980 Mendewe or Mendam, Stephen, of Gravesende, Kent, ironmonger 3
5293025 2442945 2442945 defendant Stacy Thomas yeoman 594980 594980 Stacy, Thomas, of Gravesende, Kent, yeoman 3
5293054 2442950 2442950 defendant Stacy or Stace Thomas yeoman 594980 594980 Stacy or Stace, Thomas, of Gravesende, Kent, yeoman 3
5306831 2447039 2447039 defendant Bedyll Mathew gent 594980 594980 Bedyll, Mathew, of Gravesende, Kent, gent 0
5306846 2447045 2447045 defendant Bedyll Thomas gent 594980 594980 Bedyll, Thomas, of Gravesende, Kent, gent 0
5314134 2449243 2449243 defendant Partryche Thomas chapman 594980 594980 Partryche, Thomas, of Gravesende, Kent, chapman 0
5322345 2451758 2451758 defendant Broun John taverner 594980 594980 Broun, John, of Gravesende, Kent, taverner 1
5328277 2453534 2453534 defendant Broun John yeoman 594980 594980 Broun, John, of Gravesende, Kent, yeoman 0
5347935 2459497 2459497 defendant Burstede Thomas gent 594980 594980 Burstede, Thomas, of Gravesende, Kent, gent 1
5348919 2459791 2459791 defendant Burston Thomas gent 594980 594980 Burston, Thomas, of Gravesende, Kent, gent 0
5348926 2459794 2459794 defendant Burston Thomas gent 594980 594980 Burston, Thomas, of Gravesende, Kent, gent 0
5350458 2460264 2460264 defendant Bedell Mathew yeoman 594980 594980 Bedell, Mathew, of Gravesende, Kent, yeoman 1
5351073 2460441 2460441 defendant Clerk John butcher 594980 594980 Clerk, John, of Gravesende, Kent, butcher 2
5351867 2460687 2460687 defendant Acton Thomas yeoman 594980 594980 Acton, Thomas, of Gravesende, Kent, yeoman 0
5352008 2460731 2460731 defendant Hatton Henry yeoman 594980 594980 Hatton, Henry, of Gravesende, Kent, yeoman 0
5364296 2464494 2464494 defendant Baker Gilbert (legal representative) 594980 594980 Baker, Gilbert, of Gravesende, kent, hosier, executor of 0
5369316 2466006 2466006 defendant Gylmyn Robert   594980 594980 Gylmyn, Robert, of Gravesende, Kent, inn holder 0
5370231 2466276 2466276 defendant Kyrton John   594980 594980 Kyrton, John, of Gravesende, Kent, inn holder 2
5371321 2466610 2466610 defendant Gylyng Robert husbandman 594980 594980 Gylyng, Robert, of Gravesende, Kent, husbandman 1
5429825 2483862 2483862 defendant Lorkyn William innholder 594980 594980 Lorkyn, William, of Gravesende, Kent, innholder 3
5475736 2497738 2497738 defendant Flower William salter 594980 594980 Flower, William, of Gravesende, Kent, salter 1
5542582 2517805 2517805 defendant Lorkyn William innholder 594980 594980 Lorkyn, William, of Gravesende, Kent, innholder 2
5542723 2517843 2517843 defendant Lorkyn William innholder 594980 594980 Lorkyn, William, of Gravesende, Kent, innholder 2
5565070 2524371 2524371 defendant Burston William gent 594980 594980 Burston, William, of Gravesende, Kent, gent 0
5633087 2554353 2554353 defendant Lynton John esq 594980 594980 Lynton, John, of Gravesende, Kent, esq 0
5633522 2554478 2554478 defendant Spicer William boatman 594980 594980 Spicer, William, of Gravesende, Kent, boatman 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);