Franklin Ledgers Database

Franklins' Philadelphia Ledgers Project

All Transactions

The "all_transactions" table provides a complete record of the six ledgers included in the database. Most general queries should begin here.

Detailed description of the database's data structure.

24 rows where activity contains "Negro" and controlled_description = "Advertisement"

Keyword Search:

Advanced Search:

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link	rowid ▼	transaction_id Filter by this column Hide this column Unique identifier assigned to each transaction.	date Filter by this column Hide this column Transcription of the date of the transaction.	lemay_index Filter by this column Hide this column Unique identifier assigned to each person.	full_name Filter by this column Hide this column Transcription of the name as it appears in the transaction.	occupation Filter by this column Hide this column Transcription of the occupational information that appears in the transaction.	transaction_type Filter by this column Hide this column A broad categorization of the transaction.	activity Filter by this column Hide this column Transcription of the ledger's record of the transaction.	controlled_description Filter by this column Hide this column Controlled vocabulary categorizing the type of transaction or goods exchanged.	narrow_description Filter by this column Hide this column Controlled vocabulary categorizing the specific goods and/or services exchanged.	shillings Filter by this column Hide this column Transcription of the shillings due.	line_total Filter by this column Hide this column The total number of pounds, shillings and pence due.	gazette_no Filter by this column Hide this column Number of the Pennsylvania Gazette in which the advertisement purchased in the transaction appeared.	notes Filter by this column Hide this column Transcription of any other information in the transaction.	gender Filter by this column Hide this column Gender of the person appearing in the transaction, extrapolated from the person's name.	source Filter by this column Hide this column Manuscript volume in which the transaction appears	page_number Filter by this column Hide this column Digital page number on which the transaction appears.	url Filter by this column Hide this column Link to a digitization of the page on which the transaction appears.
6621	6621	TNinLD-184	1742-09-29	Nathan Levy L0108	Mr N Levi		Dr	Advertisement Negro Woman	Advertisement	Advertisement	5	0.5.0			M	Ledger D	49	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld049
6623	6623	TNinLD-186	1737-12-22	Nathan Levy L0108	Mr N Levi		Dr	Advt in Gaz N 471 a Negro	Advertisement	Gazette	5	0.5.0	471	from work book	M	Ledger D	49	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld049
6624	6624	TNinLD-187	1738-08-03	Nathan Levy L0108	Mr N Levi		Dr	Advt in Gaz N 503 Negro Womn	Advertisement	Gazette	5	0.5.0	503	from work book	M	Ledger D	49	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld049
7787	7787	TNinLD-1290	174[]-07-23	Emmerson & Graydon E0068	Emmerson & Graydon		Dr	For Advt in Gaz N 658 of Negroes	Advertisement	Gazette	5	0.5.0	658		M	Ledger D	84	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld084
8374	8374	TNinLD-1837	1741-12-03	Mr Thomas Rogers R0183	Thos Rogers	Shoemaker	Dr	Advt in Gaz N 677 of a young Negro	Advertisement	Gazette	5	0.5.0	677		M	Ledger D	106	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld106
8424	8424	TNinLD-1882	1737-10-06	Mr Anthony Wilkinson W0163	Mr Antony Wilkinson		Dr	Advt in Gazette A Negro Man to Sell	Advertisement	Gazette	5	0.5.0			M	Ledger D	109	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld109
8640	8640	TNinLD-2091	1743-05-05	Mr William Chancellor C0097	Mr Wm Chancellor		Dr	Advt 3 Negro Men	Advertisement	Advertisement	5	0.5.0			M	Ledger D	118	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld118
8641	8641	TNinLD-2092	1743-07-28	Mr William Chancellor C0097	Mr Wm Chancellor		Dr	Advt 3 Negro Men	Advertisement	Advertisement	5	0.5.0		Do	M	Ledger D	118	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld118
9108	9108	TNinLD-2540	1742-08-14	Mr William Branson B0307	Mr William Branson		Dr	Advt of runaway Negro	Advertisement	Advertisement	8	0.8.0			M	Ledger D	131	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld131
9642	9642	TNinLD-3033	1738-05-18	Mr Robert Ellis E0051	Mr Robert Ellis		Dr	Advt of Negroes Gaz N 492	Advertisement	Gazette	5	0.5.0	492	from Work Book	M	Ledger D	155	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld155
9644	9644	TNinLD-3035	1740-09-04	Mr Robert Ellis E0051	Mr Robert Ellis		Dr	Advt in Gaz of Negroes for Sale	Advertisement	Gazette	5	0.5.0		from Work Book	M	Ledger D	155	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld155
9876	9876	TNinLD-3263	1741-12-02	Mr Thomas Rogers R0183	Mr Thos Rogers	Shoemaker	Dr	Advt for the sale of a Negroe Boy	Advertisement	Advertisement	5	0.5.0			M	Ledger D	164	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld164
9912	9912	TNinLD-3299	1738-09-14	John Clifton Esqr C0171	Jno Clifton Esqr		Dr	Advt in Gaz N 509 Negro Boy	Advertisement	Gazette	5	0.5.0	509	from Work Book	M	Ledger D	165	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld165
10294	10294	TNinLD-3655	1744-02-16	Mrs Deba Connely C0238	Mrs Deba Connely		Dr	Advt in Gaz N 792 Negro Men	Advertisement	Gazette	5	0.5.0	792		F	Ledger D	179	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld179
10567	10567	TNinLD-3916	1743-11-09	Capt John Simms S0152	Capt Jno Simms		Dr	Advt of Negroes	Advertisement	Advertisement	5	0.5.0			M	Ledger D	195	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld195
11130	11130	TNinLD-4426	1743-09-29	Mr James Morris M0150	Mr James Morris		Dr	Advt of Sale of a Negro Woman	Advertisement	Advertisement	5	0.5.0			M	Ledger D	221	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld221
11777	11777	TNinLD-5033	1745-01-01	Mr Ebenezer Currie C0382	Mr Ebenezer Currie		Dr	[Advt] in [N 838] Negro Man	Advertisement	Gazette	5	0.5.0	838		M	Ledger D	247	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld247
12219	12219	TNinLD-5454	1743-08-25	Mr Samuel Bickley B0164	Mr Samuel Bickley		Dr	[Advt] in N 767 Negro confin'd	Advertisement	Gazette	5	0.5.0	767		M	Ledger D	267	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld267
12656	12656	TNinLD-5865	1737-11-24	Capt William Atwood A0147	Capt Wm Atwood		Dr	Advt in Gazette Negro Man	Advertisement	Gazette	5	0.5.0		from Work Book	M	Ledger D	280	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld280
12660	12660	TNinLD-5869	1741-11-11	Mr Crosdale C0348	Mr Crosdale		Dr	Advt for runaway Negroe	Advertisement	Advertisement	5	0.5.0			M	Ledger D	281	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld281
12805	12805	TNinLD-6009	1742-06-22	John Ingles I0006	Mr Jno Inglis		Dr	Advt Sale Negroe Woman	Advertisement	Advertisement	5	0.5.0			M	Ledger D	290	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld290
12819	12819	TNinLD-6022	1739-07-12	John Ingles I0006	Mr Jno Inglis		Dr	Advt in Gaz N 552 Negro Woman	Advertisement	Gazette	5	0.5.0	552	from Work Book	M	Ledger D	290	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld290
12921	12921	TNinLD-6121	1743-06-02	Mr John Harrison H0092	Mr Jno Harrison	Mercht	Dr	[Advt] in N 755 Negroes	Advertisement	Gazette	5	0.5.0	755		M	Ledger D	297	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld297
14411	14411	TNinLD-7535	1743-04-07	Thomas Boyles B0286	Thomas Byles	pewterer	Dr	[Advt] in N 747 of Negro Woman	Advertisement	Gazette	5	0.5.0	747		M	Ledger D	368	https://diglib-legacy.amphilsoc.org/islandora/object/mss-b-f85-misc-ld368

Advanced export

JSON shape: default, array, newline-delimited