names

71 rows where place_id = 587939

✎ 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
3592883 1865391 1865391 defendant Auncell John dyer 587939 587939 Auncell, John, of Westgate Strete, Canterbury, dyer 2
3593380 1865562 1865562 defendant Hendeman John butcher 587939 587939 Hendeman, John, of Westgate Strete, Canterbury, butcher 1
3593382 1865562 1865562 defendant Broke William tanner 587939 587939 Broke, William, of Westgate Strete, Canterbury, tanner 3
3599635 1867529 1867529 defendant Audeley Thomas brewer 587939 587939 Audeley, Thomas, of Westgate Strete, Canterbury, brewer 0
3601126 1868015 1868015 defendant Mepeham Thomas butcher 587939 587939 Mepeham, Thomas, of Westgate Strete, Canterbury, butcher 0
3601315 1868077 1868077 defendant Kenet Christopher yeoman 587939 587939 Kenet, Christopher, of Westgate Strete, Canterbury, yeoman 0
3603471 1868752 1868752 defendant Cupper John sawyer 587939 587939 Cupper, John, of Westgate Strete, Canterbury, sawyer 2
3603702 1868829 1868829 defendant Stokfyssh Augustine butcher 587939 587939 Stokfyssh, Augustine, of Westgate Strete, Canterbury, butcher 0
3606420 1869675 1869675 defendant Mepeham Thomas butcher 587939 587939 Mepeham, Thomas, of Westgate Strete, Canterbury, butcher 0
3607346 1869958 1869958 defendant Bonour John miller 587939 587939 Bonour, John, of Westgate Strete, Canterbury, miller 0
3611613 1871300 1871300 defendant Forest John cordwainer 587939 587939 Forest, John, of Westgate Strete, Canterbury, cordwainer 0
3613857 1871989 1871989 defendant Lawene Simon draper 587939 587939 Lawene, Simon, of Westgate Strete, Canterbury, draper 1
3618033 1873261 1873261 defendant Awene Simon tailor 587939 587939 Awene, Simon, of Westgate Strete, Canterbury, tailor 1
3618052 1873269 1873269 defendant Williams Richard smith 587939 587939 Williams, Richard, of Westgate Strete, Canterbury, smith 0
3622411 1874545 1874545 defendant Lawene Simon draper 587939 587939 Lawene, Simon, of Westgate Strete, Canterbury, draper 0
3623997 1875038 1875038 defendant Lawney Simon yeoman 587939 587939 Lawney, Simon, of Westgate Strete, Canterbury, yeoman 0
3625031 1875359 1875359 defendant Clyffe Thomas capper 587939 587939 Clyffe, Thomas, of Westgate Strete, Canterbury, capper 0
3625294 1875449 1875449 defendant Carre Gilbert butcher 587939 587939 Carre, Gilbert, of Westgate Strete, Canterbury, butcher 0
3625297 1875449 1875449 defendant Mepeham Thomas butcher 587939 587939 Mepeham, Thomas, of Westgate Strete, Canterbury, butcher 3
3688054 1922427 1922427 defendant Rolf Lawrence smith 587939 587939 Rolf, Lawrence, of Westgate Strete, Canterbury, smith 0
3718957 1932209 1932209 defendant Vawce Robert butcher 587939 587939 Vawce, Robert, of Westgate Strete, Canterbury, butcher 0
3722676 1933356 1933356 defendant Glover John butcher 587939 587939 Glover, John, of Westgate Strete, Canterbury, butcher 1
3738520 1938257 1938257 defendant Glover John butcher 587939 587939 Glover, John, of Westgate Strete, Canterbury, butcher 0
5076991 2379616 2379616 defendant Sutton Ralph yeoman 587939 587939 Sutton, Ralph, of Westgate Strete, Canterbury, yeoman 1
5118845 2391945 2391945 defendant Alshorn Thomas laborer 587939 587939 Alshorn, Thomas, of Westgate Strete, Canterbury, laborer 0
5237348 2426507 2426507 defendant Harnell William tanner 587939 587939 Harnell, William, of Westgate Strete, Canterbury, tanner 0
5250366 2430228 2430228 defendant Lacy Joan widow 587939 587939 Lacy, Joan, of Westgate Strete, Canterbury, widow 0
5250367 2430228 2430228 defendant Petman William chapman 587939 587939 Petman, William, of Westgate Strete, Canterbury, chapman 1
5259875 2433211 2433211 defendant Lyghtfote John butcher 587939 587939 Lyghtfote, John, of Westgate Strete, Canterbury, butcher 0
5263947 2434484 2434484 defendant German Robert roper 587939 587939 German, Robert, of Westgate Strete, Canterbury, roper 0
5265529 2434981 2434981 defendant Luton William butcher 587939 587939 Luton, William, of Westgate Strete, Canterbury, butcher 0
5265530 2434981 2434981 defendant Colyn Thomas butcher 587939 587939 Colyn, Thomas, of Westgate Strete, Canterbury, butcher 1
5280876 2439480 2439480 defendant Cobbe Alice widow 587939 587939 Cobbe, Alice, of Westgate Strete, Canterbury, widow 0
5319427 2450903 2450903 defendant Johnson Cornelius cordwainer 587939 587939 Johnson, Cornelius, of Westgate Strete, Canterbury, cordwainer 0
5323933 2452240 2452240 defendant Peyrs Richard brewer 587939 587939 Peyrs, Richard, of Westgate Strete, Canterbury, brewer 0
5346467 2459040 2459040 defendant Marley John tanner 587939 587939 Marley, John, of Westgate Strete, Canterbury, tanner 0
5355979 2461953 2461953 defendant Chamberleyn Robert butcher 587939 587939 Chamberleyn, Robert, of Westgate Strete, Canterbury, butcher 0
5479349 2498841 2498841 defendant Fylle Richard yeoman 587939 587939 Fylle, Richard, of Westgate Strete, Canterbury, yeoman 0
5481473 2499391 2499391 defendant Croft William butcher 587939 587939 Croft, William, of Westgate Strete, Canterbury, butcher 2
5481478 2499392 2499392 defendant Croft William butcher 587939 587939 Croft, William, of Westgate Strete, Canterbury, butcher 2
5481483 2499393 2499393 defendant Crofte William butcher 587939 587939 Crofte, William, of Westgate Strete, Canterbury, butcher 2
5481679 2499452 2499452 defendant Sprotte William smith 587939 587939 Sprotte, William, of Westgate Strete, Canterbury, smith 0
5482215 2499624 2499624 defendant Dewe Nicholas yeoman 587939 587939 Dewe, Nicholas, of Westgate Strete, Canterbury, yeoman 0
5486544 2500867 2500867 defendant Grenebank Christopher armorer 587939 587939 Grenebank, Christopher, of Westgate Strete, Canterbury, armorer 0
5489694 2501801 2501801 defendant Comyn Thomas smith 587939 587939 Comyn, Thomas, of Westgate Strete, Canterbury, smith 0
5489695 2501801 2501801 defendant Johnson Robert smith 587939 587939 Johnson, Robert, of Westgate Strete, Canterbury, smith 1
5490837 2502156 2502156 defendant Peale Geoffrey yeoman 587939 587939 Peale, Geoffrey, of Westgate Strete, Canterbury, yeoman 0
5494301 2503199 2503199 defendant Marley John beer brewer 587939 587939 Marley, John, of Westgate Strete, Canterbury, beer brewer 0
5504609 2506362 2506362 defendant Johnson Robert smith 587939 587939 Johnson, Robert, of Westgate Strete, Canterbury, smith 1
5516086 2509879 2509879 defendant Lanne Simon draper 587939 587939 Lanne, Simon, of Westgate Strete, Canterbury, draper 1
5528147 2513368 2513368 defendant Thomas John yeoman 587939 587939 Thomas, John, of Westgate Strete, Canterbury, yeoman 0
5528148 2513368 2513368 defendant Couper John sawyer 587939 587939 Couper, John, of Westgate Strete, Canterbury, sawyer 1
5535509 2515633 2515633 defendant Man John gent 587939 587939 Man, John, of Westgate Strete, Canterbury, gent 1
5535510 2515633 2515633 defendant Percyvalle John yeoman 587939 587939 Percyvalle, John, of Westgate Strete, Canterbury, yeoman 2
5539948 2516977 2516977 defendant Ferrour William smith or husbandman 587939 587939 Ferrour, William, of Westgate Strete, Canterbury, smith or husbandman 1
5543675 2518131 2518131 defendant Stokfisshe Augustine butcher 587939 587939 Stokfisshe, Augustine, of Westgate Strete, Canterbury, butcher 0
5546178 2518874 2518874 defendant Stokfysshe Augustine butcher 587939 587939 Stokfysshe, Augustine, of Westgate Strete, Canterbury, butcher 0
5547492 2519284 2519284 defendant Stokfissh Augustine butcher 587939 587939 Stokfissh, Augustine, of Westgate Strete, Canterbury, butcher 4
5553902 2521180 2521180 defendant Belser George yeoman 587939 587939 Belser, George, of Westgate Strete, Canterbury, yeoman 1
5573444 2526789 2526789 defendant Balle Joan widow 587939 587939 Balle, Joan, of Westgate Strete, Canterbury, widow 4
5573446 2526789 2526789 defendant Pette Isabel widow 587939 587939 Pette, Isabel, of Westgate Strete, Canterbury, widow 6
5573833 2526914 2526914 defendant Barbour John tiler 587939 587939 Barbour, John, of Westgate Strete, Canterbury, tiler 1
5573834 2526914 2526914 defendant Horsley John laborer 587939 587939 Horsley, John, of Westgate Strete, Canterbury, laborer 2
5573835 2526914 2526914 defendant Ferer Richard weaver 587939 587939 Ferer, Richard, of Westgate Strete, Canterbury, weaver 3
5573836 2526914 2526914 defendant Strydwyke Henry weaver 587939 587939 Strydwyke, Henry, of Westgate Strete, Canterbury, weaver 4
5574691 2527159 2527159 defendant Brande John cooper 587939 587939 Brande, John, of Westgate Strete, Canterbury, cooper 0
5577304 2527957 2527957 defendant Quadryng John merchant 587939 587939 Quadryng, John, of Westgate Strete, Canterbury, merchant 0
5589776 2531794 2531794 defendant Brande John cooper 587939 587939 Brande, John, of Westgate Strete, Canterbury, cooper 0
5598331 2534364 2534364 defendant Ros William gent 587939 587939 Ros, William, of Westgate Strete, Canterbury, gent 3
5600769 2535131 2535131 defendant Wadell John butcher 587939 587939 Wadell, John, of Westgate Strete, Canterbury, butcher 1
5607369 2537200 2537200 defendant Mepeham Thomas butcher 587939 587939 Mepeham, Thomas, of Westgate Strete, Canterbury, butcher 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);